Adrien Obernesser’s Post

#PostgreSQL 17 is now GA! Congrats to everyone who worked hard on this release, and for continuing to help make PostgreSQL faster and more fun to use 😉 And while I think PostgreSQL 17 includes some impressive features, it's also important to see how much PostgreSQL has advanced through the culmination of many years of open source development. Check it out, and try it out! https://lnkd.in/eix285Mc

New post! I talk with Philippe Noël about ParadeDB, the experience of building as a PostgreSQL extension, pg_duckdb, pg_lakehouse, and more...

In PostgreSQL, you may need to know the current state of a running query. One of the solution is pg_query_state module. To enable this extension you have to patch the stable version of PostgreSQL, recompile it and deploy new binaries. If you are interested, you can check it; https://lnkd.in/dKWp_shG

Release of PostgreSQL 17.0: ▫️ up to 20x less memory for Vacuum ▫️ JSON Support ▫️ up to 2x better write I/O for highload ▫️ sslnegotiation option for direct TLS handshakes using ALPN ▫️ pg_basebackup now supports incremental backups https://lnkd.in/dM6nX2Hm

Getting connected to PostgreSQL for the first time - Simple Talk

Postgres 17 has rich set of query performance improvements. I tried to capture some of the important ones in the blog. To know more, click here:

PostgreSQL 17 has just been released! 🐘 Postgres continues to evolve impressively, adapting to our fast-changing tech landscape while maintaining its core strength. My advice to tech leaders and founders: Start with Postgres and push it to its limits. More often than not, you'll find the limitation is your own expertise, not Postgres itself. I'm glad I didn't write it off after my first disastrous encounter in 2012 (I accidentally deleted a database as a student!). Now, 12 years later, I'm most excited about the new `JSON_TABLE` feature in version 17. It elegantly bridges the gap between JSON data and strictly-typed relations, streamlining data manipulation. Read more here: https://lnkd.in/eifeR6B6

The future of Postgres? Stability and reliability are core to Postgres. New features will come from extensions, which allow developers to create other storage backends, new types, and more. There are a lot of extensions available. This article covers a few of the extensions that hint at the potential of Postgres' future. https://lnkd.in/dyXk2X7f

New Features We're Looking Forward to in PostgreSQL 17 (scheduled for September)! 👇 In PostgreSQL 17, we're seeing some exciting changes that promise to modernize and enhance the database's performance and usability. Notable features include: 👥pg_createsubscriber 💪 Support for MERGE PARTITIONS and SPLIT PARTITIONS 📁 Add support for incremental file system backup 🔁 Enable the failover of logical replication slots 💡 Allow EXPLAIN to report optimizer memory usage These updates are designed to meet the evolving needs of enterprise users and applications, ensuring #PostgreSQL remains a robust and versatile platform. We're excited to contribute to these advancements, helping to shape PostgreSQL into a more powerful and efficient database for the future. 🔗 Read more here: https://lnkd.in/gAjnCJ-i

My talk on Discovering #PostgreSQL: My Journey into the number 1 #OpenSource relational database. A huge thanks to #PGConfNYC and #PGConfEU, and a special thanks to Stefanie Janine Stölting, Karen Jex & Derk van Veen. I am looking forward to contributing to the Global PostgreSQL Developer Community!