--- title: "How 2024 went for Postgres" publication: "Postgres Weekly" issue: 582 published_at: "2024-12-18" canonical_url: "https://postgresweekly.com/issues/582" --- Plus we're moving the newsletter to Thursday in 2025. | #​582 β€” December 18, 2024 [Web Version](https://postgresweekly.com/issues/582) πŸŽ„ This week we're covering a few recent items but will then head into a 2024 roundup of how things went in the Postgres world, as well as the most clicked items of the year, in case you missed them at the time. **We're taking a Christmas break for two weeks and will be back on January 9, 2025,** so we hope you have a Merry Christmas and a Happy New Year! __ _Peter Cooper and the Cooperpress team_ Together with [![Timescale logo\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_1500,h_362/e_make_transparent/co_white,e_outline:30/qjz9oczunihxrp2w6fhc.png)](https://github.com/timescale/pgai) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/vmbtuivmasdxjezkw6xn.jpg)](https://stborden.wordpress.com/2024/12/17/some-of-my-favorite-things-postgres-queries/) [Some of My Favorite Things – Postgres Queries](https://stborden.wordpress.com/2024/12/17/some-of-my-favorite-things-postgres-queries/) β€” There’s not _really_ any big Postgres news this week, so why not enjoy this festive gift of some (reasonably complex) SQL queries Shane uses to track database usage in various ways, to see unused indexes, to generate a vacuuming report, and more. Shane Borden [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/1cffa55e.png)](https://github.com/timescale/pgai) [Building AI Apps on Postgres? Start with pgai](https://github.com/timescale/pgai) β€” pgai is a PostgreSQL extension that brings more AI workflows to PostgreSQL, like embedding creation and model completion. pgai empowers developers with AI superpowers, making it easier to build search and retrieval-augmented generation (RAG) applications. Timescale sponsor [pg_incremental: Incremental Data Processing in Postgres](https://www.crunchydata.com/blog/pg_incremental-incremental-data-processing-in-postgres) β€” Marco introduces a new Postgres extension offering automated, incremental batch processing for creating reliable processing pipelines. [GitHub repo.](https://github.com/crunchydata/pg_incremental) Marco Slot πŸ“„ [Exploring Postgres's Arena Allocator by Writing an HTTP Server from Scratch](https://www.enterprisedb.com/blog/exploring-postgress-arena-allocator-writing-http-server-scratch) – An odyssey that's not for the faint of heart! Phil Eaton πŸ“„ [Quick Benchmark of Improvements to Large Object Dumping in Postgres 17](https://www.credativ.de/en/blog/postgresql-en/quick-benchmark-improvements-to-large-object-dumping-in-postgres-17/) Michael Banck πŸ“„ [Shrinking a Postgres Table](https://www.johnnunemaker.com/shrinking-a-postgres-table/) John Nunemaker **QUICK BITS:** - πŸ—“οΈ It might be too early to book your flights, but if you want to go to [_PostgreSQL Conference Europe 2025_](https://2025.pgconf.eu/), you'll need to pencil in being in Riga, Latvia on October 21-24, 2025. - This year, Timescale's annual Postgres community survey attracted several hundred responses and they [provide a sneak peek at the responses](https://www.timescale.com/blog/state-of-postgresql-2024), along with [πŸ“„ a full (rather well designed) PDF report here.](https://s3.amazonaws.com/assets.timescale.com/state-of-postgresql/Report_State_of_PostgreSQL_2024.pdf) - πŸ‡©πŸ‡° [Registration for Nordic PGDay 2025](https://2025.nordicpgday.org/registration/) is now open. It takes place in Copenhagen next March and [its CFP](https://2025.nordicpgday.org/cfp/) is open till December 31. - Regina Obe [ponders the 'bus factor' problem](https://www.bostongis.com/blog/index.php?/archives/285-The-bus-factor-problem.html) (a slightly morbid way to measure resiliency of a project to 'losing' core contributors) and how to be prepared to add new core team members as needed. - 🎧 The [_Postgres FM_ podcast](https://postgres.fm/) just had [jOOQ's Lukas Eder on](https://postgres.fm/episodes/jooq) for an interview. πŸ₯‡ Top Developments and Items of 2024 2024 was another great year for Postgres. Here are some of the highlights, plus one sad development, looking back: - The year started strong with [DB Engines billing Postgres as 'DBMS of the Year 2023'.](https://db-engines.com/en/blog_post/106) I wonder if we'll get it for 2024 too? - [Tembo hired PGXN creator David Wheeler](https://tembo.io/blog/welcoming-david-wheeler) to work on [ways to improve](https://gist.github.com/theory/898c8802937ad8361ccbcc313054c29d) the Postgres extension ecosystem – work he has diligently been progressing all year. Here's [the latest update.](https://tembo.io/blog/extension-ecosystem-summit) - [Postgres 17 was released](https://www.postgresql.org/about/news/postgresql-17-released-2936/) in September with overhauled memory management, incremental backup support, faster B-tree index scans, `MERGE` improvements, and more. It was [a great release.](https://www.cybertec-postgresql.com/en/whats-so-great-about-postgresql-v17/) - [pgvector](https://github.com/pgvector/pgvector) continued to find its way into everything and had a handful of significant releases (most lately [v0.8.0](https://www.thenile.dev/blog/pgvector-080)) with [performance going from strength to strength.](https://jkatz05.com/post/postgres/pgvector-performance-150x-speedup/) - ElectricSQL [unveiled PGLite,](https://pglite.dev/) a way to run a complete Postgres database in WebAssembly environments (including the browser). - Postgres creator Mike Stonebraker [unveiled his new company, DBOS.](https://www.dbos.dev/blog/announcing-dbos) - πŸ—“οΈ Microsoft's virtual _Citus Con_ event rebranded to [POSETTE](https://www.citusdata.com/posette/2024/) and was a roaring success in 2024. [The 2025 edition](https://posetteconf.com/2025/) is in June and [its CFP](https://posetteconf.com/2025/cfp/) is open. [PGConf.dev](https://2025.pgconf.dev/) also went well and you can [watch the talks here.](https://www.youtube.com/playlist?list=PLTw6f6dqzO1tTW6Ka_bou9rs5YTNxD8Xr#pgconfdev2024) - Amazon teased its [new Aurora DSQL database](https://aws.amazon.com/rds/aurora/dsql/features/) just two weeks ago. - And, absolutely not a highlight but important to recognize and remember, we sadly [said goodbye to Postgres maintainer Simon Riggs](https://m6n.io/@fuzzychef/112172393647826741) who passed away in March. May he rest in peace. Now, for the top 5 links of the year based upon reader engagement: [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/zcbeoxdnt3q3lcaylod7.jpg)](https://aiven.io/developer/sql-query-optimization-guide) 1. [SQL Query Optimization: A Comprehensive Developer's Guide](https://aiven.io/developer/sql-query-optimization-guide) β€” A bumper packed post digging into the optimization of `SELECT`, `INSERT`, and `DELETE` queries, covering areas like using indexes, paginating results, avoiding joins, and how window functions can help (or not). Not Postgres-only but written with Postgres in mind. Francesco Tisiot 2. [Optimizing Postgres Table Layout for Maximum Efficiency](https://r.ena.to/blog/optimizing-postgres-table-layout-for-maximum-efficiency/) β€” The _alignment_ of data within broader data structures has long been an important factor for optimization in low level programming, but it can affect your Postgres tables too. Renato looked at how table layout can impact both storage efficiency and query performance. Renato's Runtime Reflections 3. [Can Postgres Replace Redis as a Cache?](https://medium.com/redis-with-raphael-de-lio/can-postgres-replace-redis-as-a-cache-f6cba13386dc) β€” Redis is a popular, high performance in-memory data storage server commonly used for caching, but if we can [just use Postgres for everything](https://www.amazingcto.com/postgres-for-everything/), could Postgres take on the job instead? Raphael De Lio 4. [pgPedia: A Postgres Encyclopedia of Sorts](https://pgpedia.info/) β€” An interesting, cleanly formatted wiki-esque reference guide to Postgres’ features and settings that complements the official documentation well. Well worth poking around a bit. Postgrespedia 5. [Hacking on PostgreSQL is Really Hard](https://rhaas.blogspot.com/2024/05/hacking-on-postgresql-is-really-hard.html) β€” Robert has consistently been in the top ten committers to Postgres for many years, but this year he reflected on just how intimidating the process of contributing to Postgres can be, especially for newcomers. Robert Haas πŸ‘‹ We are now off for two weeks for our Christmas break. Merry Christmas if you celebrate too. We return on _Thursday_, January 9, 2025 (yes, we're changing the day Postgres Weekly goes out in the new year – keeps things interesting!) **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|*).