~postgresweekly | Issue 568 - The State of PostgreSQL survey is back (8)

Top 3 Features in Postgres 17 — As we continue our final approach towards Postgres 17, likely to land later this month, Neon reflects on improvements to MERGE, improved JSON functions, and performance improvements. EDB wrote up its own list of Postgres 17 enhancements too, with incremental backup support topping their list.

Master PostgreSQL Extensions: Pgvector, Citus, TimescaleDB — Unlock the full potential of PostgreSQL with our expert-led webinar series on Pgvector, Citus, and TimescaleDB. Learn integration, scaling, and best practices to optimize your database performance. Watch now to elevate your PostgreSQL game!

The 2024 State of PostgreSQL Survey is Now Open — Timescale’s popular annual community survey is open once again. You can take it here and it closes on Monday, September 30. If you’re hungry for some stats now, you can check out the 2023 survey’s results here.

pg_stat_monitor 2.1: Query Performance Monitoring Tool — Along similar lines to pg_stat_statements but promises to be a ‘more advanced replacement.’ One particularly neat feature is the bucketing of statistics by time, enabling more finessed use of the data collected. GitHub repo.

Pigsty v3.0: An Extension-Rich Postgres Distribution — Pigsty is a Postgres distribution that promises ‘batteries included’. It offers an RDS-like platform but to deploy as you wish. It now lets you easily install 336 further extensions as well.

pg_hint_plan 1.7: Tweak Query Execution Plans with 'Hints' — Postgres’ query planner usually does a good job of figuring out how to best execute a query against your data, but when it needs a little extra push in the right direction, this lets you drop some hints. With v1.7, Postgres 17 support has been added.

PgCat 1.2: Modern Postgres Pooler and Proxy — Built in Rust, PgCat offers support for sharding (including, experimentally, based upon SQL syntax), load balancing and failover support.

pg_easy_replicate Now Supports Schema Change Tracking During Logical Replication — pg_easy_replicate makes it easy to set up logical replication and perform minimal downtime switchovers between primary database servers. It now supports DDL change tracking too.