AutoVacuum Archives - 2ndQuadrant

Posts

PostgreSQL VACUUM and ANALYZE Best Practice Tips

VACUUM and ANALYZE are the two most important PostgreSQL database maintenance operations. A vacuum is used for recovering space occupied by “dead tuples” in a table. A dead tuple is created when a record is either deleted or updated (a delete followed by an insert). PostgreSQL doesn’t physically remove the old row from the table […]

Postgres Vacuuming Through Pictures [Webinar]

August 20, 2020/0 Comments/in Liaqat's PlanetPostgreSQL, Webinars /by Liaqat Andrabi

Vacuuming is a key feature of PostgreSQL databases to keep databases healthy and optimized. When enabled, autovacuum conserves space by removing obsolete disk usage and optimizes database performance by speeding up sequential scans, among many other benefits. As part of the ongoing PostgreSQL Webinar Series, 2ndQuadrant hosted a webinar on Postgres Vacuuming Through Pictures, which […]

PG Phriday: 10 Things Postgres Could Improve – Part 1

June 12, 2020/3 Comments/in Shaun's PlanetPostgreSQL /by Shaun Thomas

Postgres is a database software engine with a lot to love, and certainly a non-zero amount to hate. Rather than approaching the topic from a glib and clickbaity angle, let’s see what’s really lurking in those dark recesses, and how we may potentially address them. Though the original blog post calling out Postgres’ faults gave […]

When autovacuum does not vacuum

April 19, 2017/9 Comments/in 2ndQuadrant, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas Vondra

A few weeks ago I explained basics of autovacuum tuning. At the end of that post I promised to look into problems with vacuuming soon. Well, it took a bit longer than I planned, but here we go. To quickly recap, autovacuum is a background process cleaning up dead rows, e.g. old deleted row versions. […]

Autovacuum Tuning Basics

March 2, 2017/12 Comments/in 2ndQuadrant, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas Vondra

A few weeks ago I covered the basics of tuning checkpoints, and in that post I also mentioned that the second common source of performance issues is autovacuum (based on what we see on the mailing list and at our customers under support). So let me follow-up on that with this post about the basics […]

Committed to the PostgreSQL Community, 2ndQuadrant Contributes to 9.6

September 29, 2016/3 Comments/in 2ndQuadrant, Featured, Umair's PlanetPostgreSQL /by Umair Shahid

The latest version of PostgreSQL 9.6 is planned to be released later today, bringing with it some much anticipated features and updates. As the most advanced open source database, PostgreSQL strives to release a major version roughly once every year. With an active and collaborative community, this PostgreSQL release boasts impressive features and updates thanks […]

2ndQuadrant is now part of EDB

Posts

PostgreSQL VACUUM and ANALYZE Best Practice Tips

Postgres Vacuuming Through Pictures [Webinar]

PG Phriday: 10 Things Postgres Could Improve – Part 1

When autovacuum does not vacuum

Autovacuum Tuning Basics

Committed to the PostgreSQL Community, 2ndQuadrant Contributes to 9.6

Support & Services

Products

Postgres Learning Center

About Us