G o o gl e C l o u d Optimizing, monitoring, and troubleshooting VACUUM operations in PostgreSQL Amarnadh Sai Eluri Software Engineer June 20, 2020G o o g l e C l o u d 2 Introduction 3 Overview of MVCC 3 Overview of the VACUUM operation 5 Syntax 5 Reclaim space 7 Freeze transaction ID 7 The autovacuum process 8 Monitoring and tuning VACUUM operations 9 Memory 9 Freeze transaction IDS 10 Monitor transaction IDs 11 Query that identifies the database with the oldest transaction ID 13 Query that identifies tables that need the VACUUM operation 14 Reclaim storage space 15 Track operations on tables 16 Query that identifies logically insert, updated, and deleted rows per table 16 Query that identifies dead tuples 17 Throttle the autovacuum process 18 Query that identifies the default values of

Join for free to read