1

I'm just wondering what version of PostgreSQL first implemented autovacuum.

1

Prior to PostgreSQL 8.1 it was an extension; 8.1 moved autovacuum into the distribution and away from pg_autovacuum, from the release notes

Move /contrib/pg_autovacuum into the main server (Alvaro)

Integrating autovacuum into the server allows it to be automatically started and stopped in sync with the database server, and allows autovacuum to be configured from postgresql.conf.

But concurrent vacuuming and enabled-by-default autovacuum was introduced in 8.3,

Autovacuum is now enabled by default (Alvaro)

Several changes were made to eliminate disadvantages of having autovacuum enabled, thereby justifying the change in default. Several other autovacuum parameter defaults were also modified.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.