ads' corner

Postgres Extensions Day Montréal 2025

On Monday before PGConf.dev, the Postgres Extensions Day 2025 took place. Same venue, same floor. A day fully packed with talks, and interesting discussions.

Understanding VACUUM, VACUUM template0, and Transaction ID Wraparound

PostgreSQL uses Multi-Version Concurrency Control (MVCC) to manage concurrent access to the database, and store each version of a tuple in a table. To keep the database efficient, PostgreSQL employs a cleanup process called VACUUM, which removes unnecessary tuples. This not only saves disk space and keeps the database size under control, it also prevents the dreaded 'Transaction ID Wraparound' issue. Regularly running VACUUM is crucial, including on the template0 database, which is normally handled by the Autovacuum daemon. However, sometimes manual intervention is necessary.

PostgreSQL Development Conference 2024 - Review

Ever since its inception, PGCon took place in Ottawa, on the U of O Campus campus. I attended this conference before. Now the new PGConf.dev conference is moved to the other side of the country, and hosted on the Simon Fraser University campus in Vancouver.