Video

Terrible tutorial, so every time I need to access the processes tab I will have to make a backup of my database!? I need to access this processes tab without doing any tricks, the official postgresql profile is suggesting such a triks

First!

Useless video

pretty good

24:54 says EXPLAIN ANALYZE is not completely accurate either. Which statistics from EXPLAIN ANALYZE are not accurate? Anyway to make it accurate?

online course available????

thank u for help

Can you guys re-release this lecture with better audio?

Neat talk, well done and well presented, thanks.

Audio is very low.

Good video👍

No.

The way you explain is fantastic. Please share the pre-installation steps as well.

Thanks great presentation,

Great lecture, should be more popular!

👍

I am a new registered. My account needed to be reviewed, and I did not receive any messages from EDB, can you help me?

Thanks... I can now figure out the frames membership of : WITH cte1 AS ( SELECT * , COUNT(*) OVER w1 AS grp ,ARRAY_AGG(id1) OVER w1 AS fm1 ,ARRAY_AGG(id1) OVER w1_2 AS fm1_2 ,ARRAY_AGG(id1) OVER w2 AS fm2 ,ARRAY_AGG(id1) OVER w2_1 AS fm2_1 ,ARRAY_AGG(id1) OVER w3 as fm3 ,ARRAY_AGG(id1)OVER w4 AS fm4 ,ARRAY_AGG(id1)OVER w5 AS fm5 FROM ( VALUES (1,1, 'A'), (2,1, NULL), (3,1, NULL), (4,2, 'B'), (5,2, NULL), (6,3, 'C') ) AS x(id1, id2,col2) WINDOW w1 AS () /* w1 = w1_2= w2 = w5 */ ,w1_2 AS (RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)/* w1 = w1_2= w2 = w5 */ ,w2 AS (ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) /* w1 = w1_2= w2 = w5 */ ,w2_1 AS (ORDER BY id1 ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) /*w1= w1_2= w2 = w5 */ ,w3 AS (ORDER BY id1) /* w3= w4 */ ,w4 AS (ORDER BY id1 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) /* w3= w4 */ ,w5 AS (ORDER BY id1 RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) /* w1 = w1_2= w2 = w5 */ ) SELECT * FROM cte1

bookmark: 23:02

Any possibility of getting the slides?

This was great presentation

Do Aurora Serverless v2 supports FDW?

damm it, that easy and that hidden, tahnaks

great webinar, thanks. :))

Got this working thanks

Thank u Sir Good explanation.

Very good video. How were you able to have all columns on the y axis. Only the PK is appearing on my Y axis.

how much cost will it incur is it free?

it is not a perfect tutorial for beginner, if you are beginner please don't see thsi video, it makes you confuse.

Что она говорит? На каком языке? Ни фуя не понятно

do you have a video on How to install the pldgbapi extension?

Thank you for a very interesting presentation. What are the tradeoffs with using a single table approach as shown in this example, vs a separate table for the relationships? Would there be any good reasons to choose one over the other? Thanks!

Is there a way for pgAdmin to generate the visualization of already existing tables? While you draw the tables and draw the connections, the pgAdmin generated queries to create the tables in database, but is it possible to do it opposite way? I have database with tables that are created by python and I want them to be displayed graphically like you draw them. Thanks in advance!

thanks

i can see the pg admin ubuntu installed on my system but when i click it, it wont open.

Please someone correct me if I'm wrong, but he didn't address the ability to add and query properties of edges. It does not seem possible given his modeling assumptions. His examples were based in a single table (each row is a node) so you could only add properties to nodes (by adding columns to that table).

pg_dumpall: error: aborting because of server version mismatch pg_dumpall: detail: server version: 16.0 (Debian 16.0-1.pgdg120+1); pg_dumpall version: 15.4 how to downgrade the version in docker

Do you have any tutorials for authenticating users on active directory to Postgresql running on Windows? Thank you.

Publications and Subscriptions are not available in my case. I'm using Postgresql 12.4 and Pgadmin 4.24

7:20

excellent video!

Thanks Simon, this helped me a lot just now!

Hi , thanks for the video,. How I can contact you for guidance and support?

Thanks for this, I just went through a very similar exercise on production tables before finding this video and almost everything you covered overlapped with my observations. I wasn't creating temporary tables from underlying production data but was generating table copies in the same transaction as the tests, so your comment about vacuum (+analyze) not running within the first minute or so explained why I needed to add an analyze statement to pick an appropriate join strategy, other than e.g. merge joins. I've also experienced joining my own (large) column metadata tables to pg_catalog tables e.g. pg_class and have seen that blow up with a nested loop. I'm guessing you can't add an index or run analyze on those system tables (need to check) so the only route open to me was to encourage the optimiser to use hash joins with enable_nestloop=off

Great Session

Muy completo y enormemente instructivo, mil gracias Boriss/Edb, sobre estos tipos de replicación ¿qué sistemas operativos se recomiendan o son mas adecuados? siempre Linux?

I am actually English by birth and have spoken it for more than 60 years, and this guy speaks so quickly I can pick up about one word in three

Very clear review. Im new and self learning this but it gave very good pointers ✅️👍

Kya socha tha aur kya nikla