14:13How we keep Azure Database for PostgreSQL free of bloat to maximize disk space | Citus Con 2023
From the creator
Video recording of a conference talk about Postgres table bloat given at Citus Con: An Event for Postgres 2023, by Bob Wuisman and Eleni Siampali of Ebiquity. The team at Ebiquity was facing an issue with bloat not being removed effectively, resulting in poor database and server performance. Now they automatically updates the autovacuum settings every week on their Azure Database for PostgreSQL flexible servers. Each week Bob and Eleni add new client database servers to our Azure Database for PostgreSQL Flexible Server subscription. Each database is different in size and activity. Some are less than 300GB with daily insert, update, and delete activities; some are more than 10 GB with little frequent changes; and then we have everything in between. This changes per table in the databases as well. Bob’s and Eleni’s automation of autovacuum has improved and stabilized Postgres query performance significantly—and has saved consistently more than one TB of server disk space. The weekly automatic updates to the following autovacuum parameters, based on segmenting the database tables in different clusters: ■ Autovacuum_vacuum_cost_limit (increase) ■ Autovacuum_vacuum_cost_delay (reduce) They discuss the 7 steps of their workflow: 1. Design the solution 2. Collect database statistics 3. Segment the database tables 4. Determine the autovacuuming factors 5. Automatically update the factors on each table 6. Return diskspace back to the server 7. Analyze results and adj
Published 2023-05-08 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.





