--- title: "Postgres - the database of the year in 2023" publication: "Postgres Weekly" issue: 537 published_at: "2024-01-10" canonical_url: "https://postgresweekly.com/issues/537" --- Plus thoughts on Postgres's future, incremental backups, and a swathe of Postgres events. | #​537 — January 10, 2024 [Web Version](https://postgresweekly.com/issues/537) Together with [![Neon\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_2120,h_600/e_make_transparent/co_white,e_outline:17/lxijdjg4shxsbq3u3whs.png)](https://neon.tech/blog/change-data-capture-with-serverless-postgres?utm_source=cooperpress&utm_medium=newsletter&utm_campaign=postgresweekly) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/h0xbupjdciyomnzbp002.jpg)](https://db-engines.com/en/blog_post/106) 🏆 [PostgreSQL: The DBMS of the Year 2023](https://db-engines.com/en/blog_post/106) — [DB-Engines](https://db-engines.com/en/) is a long-established site that collects information about ([480 and counting](https://db-engines.com/en/systems)) database systems, tracks their relative popularity, and shares which database gained the most relative popularity over the prior year. This time, it’s Postgres! Gelbmann and Andlinger (DB Engines) [Thoughts on Postgres in 2024](https://jkatz05.com/post/postgres/postgresql-2024/) — Postgres is in a good place, says Jonathan, who touches on a vast array of topics that relate to Postgres’s short term future, including feature gaps in replication, non-blocking schema changes, the ability to replay changes in parallel, as well as community building efforts. Jonathan Katz [![\](https://copm.s3.amazonaws.com/928e6599.png)](https://neon.tech/blog/change-data-capture-with-serverless-postgres?utm_source=cooperpress&utm_medium=newsletter&utm_campaign=postgresweekly) [Change Data Capture on Neon Serverless Postgres](https://neon.tech/blog/change-data-capture-with-serverless-postgres?utm_source=cooperpress&utm_medium=newsletter&utm_campaign=postgresweekly) — Standard Postgres CDC via logical replication is now available on Neon. Sync changes to OLAP databases, stream updates to Kafka, the possibilities are, like the WAL, endless! Neon Serverless Postgres sponsor [Postgres 17 Adds Support for Incremental Backup](https://www.depesz.com/2024/01/08/waiting-for-postgresql-17-add-support-for-incremental-backup/) — Postgres 17 is still several months away, but it’s great to see features like this being committed. Robert Haas shares [some thoughts on use cases.](https://rhaas.blogspot.com/2024/01/incremental-backups-evergreen-and-other.html) Hubert (depesz) Lubaczewski _IN BRIEF:_ - 🇮🇳 [PGConf India](https://pgconf.in/conferences/pgconfin2024) has just shared its schedule for 2024 and opened ticket sales. It takes place at the end of February in Bengaluru. - 🇪🇺 The schedule for [FOSDEM PGDay 2024](https://2024.fosdempgday.org/) has been released. It's on February 2 in Brussels, Belgium – tickets are available. - 🇧🇪 Also in Belgium, there's a 'save the date' for [PGConf.BE](https://www.postgresql.org/about/news/pgconfbe-2024-mark-your-calendar-may-7th-2777/) taking place on May 7. - 📅 If you're looking to _speak_ at a Postgres event, Claire Giordano wrote in to tell us that [PGDay Chicago](https://2024.pgdaychicago.org/callforpapers/) and [PGConf.dev](https://2024.pgconf.dev/cfp/) both have CFPs closing next Monday. - Peter Eisentraut shares his [experiences with using `clangd` with Emacs](https://peter.eisentraut.org/blog/2024/01/03/using-clangd-for-postgresql-development) to work on the Postgres codebase. - pgAnalyze has created [a VACUUM simulator](https://pganalyze.com/blog/exploring-postgres-vacuum-with-vacuum-simulator). It's part of their commercial offering, but the writeup is interesting on its own. - [AWS has announced](https://www.datanami.com/2024/01/08/aws-cancels-serverless-postgres-service-that-scales-to-zero/) that Amazon Aurora Serverless v1, which notably can scale down to zero, will no longer be supported after 2024. - _The Register_ has a feature on Postgres pioneer Michael Stonebraker about how he ['promises to upend the database' once more.](https://www.theregister.com/2023/12/26/michael_stonebraker_feature/) [My Postgres Wishlist](https://ryanguill.com/postgresql/sql/2024/01/08/postgresql-wishlist.html) — We love Postgres, but it could always be better _[citation needed]_ 😏. Ryan wants to start a conversation around some ideas for improvements he’s had – there’s not much that'll be controversial here, it’s a solid and interesting list. Ryan Guill [How to 'Copy-and-Paste' a New Postgres Dev Env in 5 Minutes](https://ardentperf.com/2024/01/08/copy-and-paste-a-new-postgres-dev-env-in-5-min/) — Mostly aimed at folks who want to check out the Postgres source and get it up and running fast, particularly on EC2. Jeremy Schneider [The Best `pg_dump` Compression Settings in 2024](https://kmoppel.github.io/2024-01-05-best-pgdump-compression-settings-in-2024/) Kaarel Moppel 📰 Classifieds 🍐 [Tuple](https://tuple.app?utm_source=cooperpress&utm_medium=newsletter&utm_campaign=Q1_2024&utm_content=Postgres+Weekly_Classified+Listing) will change the way you think about pair programming. [Try it with your team free for 14 days](https://tuple.app?utm_source=cooperpress&utm_medium=newsletter&utm_campaign=Q1_2024&utm_content=Postgres+Weekly_Classified+Listing), no card required. 🛠 Code and Tools [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/xszg0b84fy7xhvxakrmt.jpg)](https://github.com/ossc-db/pg_rman) [pg_rman: Backup and Restore Management Tool](https://github.com/ossc-db/pg_rman) — There are numerous Postgres backup and restore tools, but pg_rman’s features include support for point-in-time recovery (PITR) and the way it can manage and catalog multiple backup versions. [Full documentation.](https://ossc-db.github.io/pg_rman/index.html) NTT OSS Center DBMS Development and Support Team [pg_savior: Extension to Prevent Dangerous DELETEs](https://github.com/viggy28/pg_savior) — Prevents accidental data loss caused by `DELETE` queries without a `WHERE` clause limiting the scope. The [implementation](https://github.com/viggy28/pg_savior/blob/main/pg_savior.c) is very simple (if a little naive in how it works) but it’s a cute idea and could be inspirational for your own similar extensions. Vignesh Ravichandran 🤖 [gptsql: LLM Chat with Your Postgres Database](https://github.com/tatari-tv/gptsql) — An experimental tool that brings together OpenAI’s GPT models and your Postgres database in order to ask questions about/'to' it in real time (well, real time-_ish_). There’s a demo video in the README that shows off the idea. Tatari [Introducing `prometheus_fdw`: Seamless Monitoring in Postgres](https://tembo.io/blog/monitoring-with-prometheus-fdw/) — "_What you have:_ all your monitoring data and analytics stored over there in Prometheus. _What you’d like to have:_ all of that data over here in your Postgres database…" Owens and Ankenman (Tembo) - [Parquet S3 FDW 1.1](https://www.postgresql.org/about/news/parquet-s3-fdw-110-released-2768/) – FDW for Parquet files on Amazon S3. - [pg_easy_replicate 2.0](https://www.shayon.dev/post/2023/363/introducing-pg_easy_replicate-2.0/) – A way to set up logical replication & switchover. - [sqlc 1.25](https://github.com/sqlc-dev/sqlc/releases/tag/v1.25.0) – Generate type-safe Go code from SQL. - [PGSync 3.1](https://github.com/toluaina/pgsync) – Postgres to Elasticsearch/OpenSearch sync. - [pgwatch2 1.12](https://github.com/cybertec-postgresql/pgwatch2) – Postgres metrics monitor/dashboard. - [pgBadger 12.4](https://github.com/darold/pgbadger) – Fast Postgres log analysis tool. - [pgwire 0.19](https://github.com/sunng87/pgwire) – Postgres wire protocol in a Rust library. - [pg_dbms_metadata v1.0.0](https://www.postgresql.org/about/news/pg_dbms_metadata-v100-released-2778/) - [InfluxDB FDW 2.1.0](https://www.postgresql.org/about/news/influxdb-fdw-210-release-2783/) **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|*).