--- title: "Doing an Aurora Postgres upgrade without downtime" publication: "Postgres Weekly" issue: 586 published_at: "2025-01-30" canonical_url: "https://postgresweekly.com/issues/586" --- Plus a neat Web table interface to Postgres databases, some CFP updates, and Bruce Momjian's AI talk. | #​586 — January 30, 2025 [Web Version](https://postgresweekly.com/issues/586) Together with [![Datadog\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_700,h_190/e_make_transparent/co_white,e_outline:10/vuhqm1wlyvxuddx1zxr8.png)](https://www.datadoghq.com/resources/datadog-postgresql-cheatsheet/?utm_source=cooperpress&utm_medium=newsletter&utm_campaign=dg-dbm-ww-postgres-cheatsheet-pg) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/utglhkoflyljfsouu4xb.jpg)](https://www.instantdb.com/essays/pg_upgrade) [A Major Aurora Postgres Upgrade with Zero Downtime](https://www.instantdb.com/essays/pg_upgrade) — Inspired by [an earlier blog post](https://eng.lyft.com/postgres-aurora-db-major-version-upgrade-with-minimal-downtime-4e26178f07a0) from the Lyft database team, two engineers set out to upgrade their small but heavily used Aurora Postgres instance without affecting their app – here’s the full story along with the problems encountered. (Note that the database _does_ go down for a few seconds, but their app didn’t need to drop any requests.) Parunashvili and Woelfel [A New Postgres Block Storage Layout for Full Text Search](https://www.paradedb.com/blog/block_storage_part_one) — [pg_search](https://github.com/paradedb/paradedb/tree/dev/pg_search) is a Postgres extension providing BM25-powered full text search but has required the use of external, non-Postgres files till now. No more. It’s now fully using Postgres block storage – here’s the why and how. Ming Ying (ParadeDB) [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/0cca5c5b.png)](https://www.datadoghq.com/resources/datadog-postgresql-cheatsheet/?utm_source=cooperpress&utm_medium=newsletter&utm_campaign=dg-dbm-ww-postgres-cheatsheet-pg) [PostgreSQL Performance Monitoring Cheatsheet](https://www.datadoghq.com/resources/datadog-postgresql-cheatsheet/?utm_source=cooperpress&utm_medium=newsletter&utm_campaign=dg-dbm-ww-postgres-cheatsheet-pg) — Start tracking vital resource and activity metrics from your PostgreSQL databases with our handy cheatsheet. You’ll have useful psql commands at your fingertips, and get a quick-start guide on using Datadog to monitor PostgreSQL performance. Datadog sponsor **QUICK BITS:** - The PostgreSQL project is once again participating in _Google Summer of Code._ [Pavlo Golub shares some info on how to get involved.](https://pashagolub.github.io/blog/2025/GSoC-2025/) - 🤖 Bruce Momjian has shared the PDF slides for his latest talk, [📄 Databases in the AI Trenches.](https://momjian.us/main/writings/pgsql/trenches.pdf) It covers vectors, text embeddings, semantic search, transformers, Retrieval-Augmented Generation (RAG), and more. - The PostgreSQL Contributors Team has unveiled [24 new individuals](https://www.postgresql.org/about/news/new-postgresql-contributors-3006/) recognized for their work in the Postgres community and on the codebase. - 🎤 Postgres contributor [Daniel Gustafsson went on the _Talking Postgres_ podcast](https://talkingpostgres.com/episodes/how-i-got-started-as-a-developer-in-postgres-with-daniel-gustafsson) to discuss how he got into programming and into Postgres in particular. - 🇩🇪 The CFP for [PostgreSQL Conference Germany](https://2025.pgconf.de/) (this May in Berlin) closes _this Saturday_ so [submit your proposals now](https://2025.pgconf.de/call-for-papers/) if you want to speak. - [Tembo Cloud now supports Postgres 17.](https://tembo.io/blog/postgres-17) [Logon Triggers in Postgres](https://www.cybertec-postgresql.com/en/logon-trigger-in-postgresql/) — In Postgres 17 you can create a trigger that occurs upon login which you could use for auditing or [even securing databases](https://www.dbi-services.com/blog/postgresql-17-login-event-triggers) in creative ways. Hans-Jürgen Schönig [VACUUM (INDEX_CLEANUP OFF) Considered Harmful](https://thebuild.com/blog/2025/01/28/vacuum-index_cleanup-off-considered-harmful/) — “_Unless you are sure you know what you are doing (that is, you are in a wraparound-point emergency), please pretend this option doesn’t exist. Really._” Christophe Pettus 📄 [A Partitioned Table Indexing Disaster](https://hdombrovskaya.wordpress.com/2025/01/26/indexing-partitioned-table-disaster/) – If you’ve ever encountered index naming conflicts then this post will likely be of interest. Henrietta Dombrovskaya 📄 [Waiting for Postgres 18: Allow Changing `autovacuum_max_workers` Without Restarting](https://www.depesz.com/2025/01/24/waiting-for-postgresql-18-allow-changing-autovacuum_max_workers-without-restarting/) Hubert depesz Lubaczewski 📰 Classifieds [Introducing Query Tuning Workbooks in pganalyze!](https://pganalyze.com/blog/introducing-postgres-query-tuning-workbooks?utm_source=PostgresWeeklyClassified01302025) Safely benchmark, experiment, and optimize your Postgres queries on production. --- 🐘 [**POSETTE: An Event for Postgres**](https://posetteconf.com/2025/cfp/) is June 10-12. The [call for proposals](https://posetteconf.com/2025/cfp/) **closes Feb. 9**. New and experienced speakers are encouraged to submit! 🛠 Code and Tools [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/dgzt4x65ox9vqxub1ujl.jpg)](https://mathesar.org/) [Mathesar: A Spreadsheet Interface to Postgres Databases](https://mathesar.org/) — An open source (GPLv3) tool providing a table-style interface to a Postgres database of your choice with the aim being to enable developers to open up databases more directly to end users. We first linked to it two years ago but v0.2 has just landed. [GitHub repo.](https://github.com/mathesar-foundation/mathesar) Mathesar [pgwatch 3.0: A Flexible Postgres Monitoring Solution](https://pgwat.ch/latest/) — [v3.0](https://github.com/cybertec-postgresql/pgwatch/releases/tag/3.0.0) adds support for Postgres 17 (including new metrics), Windows support, improved Docker support, updated docs, support for parallel sinks, and more. [GitHub repo.](https://github.com/cybertec-postgresql/pgwatch) CYBERTEC [pg_squeeze 1.8: Extension to Automate Table Bloat Cleanup](https://github.com/cybertec-postgresql/pg_squeeze) — While not a replacement for vacuuming, this extension goes a step further to gain even more space improvements in-situ and now supports Postgres 17. CYBERTEC **Got a new email?** You can [change your address here](https://postgresweekly.com/edit_subscription/*|UID|*). --- **Bored of us?** [Click here to stop getting Postgres Weekly](https://postgresweekly.com/leave/*|UID|*). --- **Got a link for us?** Reply and tell us. We can't include everything but we'll look at anything you send. _Thanks!_ --- Published by Cooper Press Ltd. Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. [Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*).