AutoVacuum Archives - 2ndQuadrant

Posts

When autovacuum does not vacuum

April 19, 2017/8 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/11 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 […]

Posts

Support & Services

Products

Postgres Learning Center

About Us