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

#PostgreSQL implements #MVCC in a slightly different way when compared to #databases like Oracle, MySQL, and others. In PostgreSQL, you'll see a different method for managing UNDO, which requires a cleanup concept called vacuum. It is now important for PostgreSQL admins/DevOps to understand the internals of autovacuum and the MVCC implementation. Let us discuss MVCC and autovacuum in this talk in detail.
This talk includes a discussion of the following topics in detail:
- MVCC and Autovacuum Internals in PostgreSQL. Tuning Autovacuum.
- Problems you may see in a busy OLTP database with untuned autovacuum settings.
- Enhancements in PostgreSQL 14
Get more on #PostgreSQL & #Database Tools + other Percona Database Talks below 👇👇👇
🎧 Watch / listen our PostgreSQL Database Podcasts ⏩ percona.tv/database-podcast
✅ Percona Operator for PostgreSQL ⏩per.co.na/kubernetes-operators
✅ Watch Percona Live 2021 Talks ⏩ percona.tv/PerconaLive2021
👨‍💻👩‍💻 PostgreSQL Jobs - Percona is Hiring ⏩ per.co.na/percona-jobs
✅PostgreSQL Support ⏩ per.co.na/postgresql-support
✅PostgreSQL info ⏩ per.co.na/postgresql-info
✅PostgreSQL events ⏩ per.co.na/pl2020
✅Percona Distribution for PostgreSQL ⏩ per.co.na/postgresql
✅Monitor your PostgreSQL For Free ⏩ percona.tv/pmm-yt
Follow Percona 👇👇👇
Twitter: per.co.na/twitter
Facebook: per.co.na/facebook
Instagram: per.co.na/instagram
LinkedIn: per.co.na/linkedin

[@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.

[@Rajkumar-dz1no]

Nice video with really superb clarity of concepts . 👏

[@gibson3730]

Nice and informative !!! Thanks a lot~

[@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.

[@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