That was great, I was really helped. Thank you.

Thanks Marc and Bruce for this great talk. I’m a developer in Malaysia 🇲🇾 and love ❤️ this database. I wanted to find out more about its history after PG executed a large query in less than a blink of an eye and peeking under the hood thru EXPLAIN ANALYZE and see all wonderful engineering that went behind this database. JSONB support is so awesome because front end developers can pass complex query requirements and PG can handle the heavy lifting.

thank u for help

this was painful to watch

I have it running on Manjaro Linux, the current solution at the moment, cool!

Assalomu aleykum Thank you very much

bummer. Was hoping to find this in english

felicidades por tu contenido y la calidad, bastante claro y bien desmenuzado. gracias..

I am curious about what, if any, changes were needed in COBOL and PL/1 programs. I assume interpreted programs don't care.

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