
Over the years of training, consulting and supporting PostgreSQL users, I have come up with a number of queries to monitor autovacuum. Monitoring autovacuum is not a new requirement, so there are already many existing monitoring queries.…

The archiver only runs when a WAL segment is complete. On a busy database that happens constantly; on a quiet one it might not happen for hours or days. archive_timeout exists to prevent the resulting “our database has been accepting…

Hello everyone, here comes a series of my annual posts about the Chicago Postgres Conference, and what I am most excited about. And I want to start with the training sessions we offer. All three training sessions are presented by my…
PgBackRest Is Dead Yesterday the maintainer of PgBackRest, David Steele, published the NOTICE OF OBSOLESCENCE. For further information please read the blog post pgBackRest is dead. Now what? by Lætitia Avrot. She also points to how to go…