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.
Posted by ads' corner on Monday, June 2, 2025
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.
Posted by ads' corner on Wednesday, June 19, 2024
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.
Posted by ads' corner on Friday, June 14, 2024