A Detailed Understanding of MVCC and Autovacuum Internals in PostgreSQL 14 - Avinash Vallarapu

[@ShivaJangam-ob3fr]

I really liked the video. When you are explaining the Transaction ID Wraparound concept is a bit confusing. You would have explained with some numbers.

[@vitache1276]

You are good at Postgresql. You never gave me the chance to work at Percon when you interviewed me. However I have gained more experience as a PostgreSQL DBA thanks to your blogs and videos. I appreciate all the work you are doing.

[@Rajkumar-dz1no]

Nice video with really superb clarity of concepts . 👏

[@gibson3730]

Nice and informative !!! Thanks a lot~

[@MansiPanchal-kp7wl]

Hello, do you know what does this query does and why sometimes it takes a long time ? /*pga4dash*/ SELECT ? AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM (SELECT (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = ?)) AS "Total", (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = ? AND datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = ?)) AS "Active", (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = ? AND datname = (SELECT datname FROM pg_catalog