--- title: "The State of PostgreSQL survey is back" publication: "Postgres Weekly" issue: 568 published_at: "2024-09-04" canonical_url: "https://postgresweekly.com/issues/568" --- Plus Postgres 17 gets a step closer, dropping hints to the query planner, and a Postgres happy hour. | #​568 — September 4, 2024 [Web Version](https://postgresweekly.com/issues/568) Together with [![Percona logo\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_600,h_120/e_make_transparent/co_white,e_outline:7/iplxngwgax1ktho5k45h.png)](https://learn.percona.com/pgweekly-postgresql-extensions-webinar-home-lp) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/wymc982loxcwpkjvzxv1.jpg)](https://neon.tech/blog/top-3-features-in-postgres-17) [Top 3 Features in Postgres 17](https://neon.tech/blog/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,](https://www.enterprisedb.com/blog/exploring-postgresql-17-new-features-enhancements) with [incremental backup support](https://pgdash.io/blog/incremental-backup-in-postgresql-17.html) topping their list. Anastasia Lubennikova (Neon) 💡 Talking of Postgres 17, it appears [release candidate 1 of Postgres 17](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=94f1474e600fdbc6b325f69903eecfeb1f69fcbd) lands this week. No announcement yet, but watch this space.. [![\](https://copm.s3.amazonaws.com/e75a99ab.png)](https://learn.percona.com/pgweekly-postgresql-extensions-webinar-home-lp) [Master PostgreSQL Extensions: Pgvector, Citus, TimescaleDB](https://learn.percona.com/pgweekly-postgresql-extensions-webinar-home-lp) — 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! Percona sponsor [The 2024 _State of PostgreSQL_ Survey is Now Open](https://www.timescale.com/blog/the-2024-state-of-postgresql-survey-is-now-open/) — Timescale’s popular annual community survey is open once again. You can [take it here](https://form.typeform.com/to/wtUFIZwA) 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.](https://www.timescale.com/state-of-postgres/2023) Timescale **QUICK BITS:** - MongoDB's CEO [claims MongoDB has racked up some recent 'wins' against Postgres](https://www.theregister.com/2024/08/30/mongodb_postgresql/) in terms of business workloads. He also made other claims including that MongoDB is _'better for developer productivity.'_ - [EDB's Amul Sul](https://postgresql.life/post/amul_sul/) is this week's _PostgreSQL Person of the Week_interviewee. - 📊 Redgate is running a [2024 State of the Database Landscape survey.](https://www.softwareandbooz.com/the-2024-state-of-the-database-landscape-survey/) - 🇦🇹 _Xata_ will be at Vienna's _Open Source Summit Europe_ on September 18 and wants to talk all things Postgres with you there. They're also [hosting a Postgres 'Happy Hour'](https://xata.io/blog/oss-vienna-happy-hour) which is open even to those not attending the summit itself. 📄 [How to Test a PostgreSQL Commitfest Patch in Kubernetes](https://www.gabrielebartolini.it/articles/2024/09/how-to-test-a-postgresql-commitfest-patch-in-kubernetes/) Gabriele Bartolini 📄 [VACUUM: Managing and Detecting Bloat](https://www.cybertec-postgresql.com/en/vacuum-managing-and-detecting-bloat/) Hans-Jürgen Schönig 🛠 Code and Tools [pg_stat_monitor 2.1: Query Performance Monitoring Tool](https://docs.percona.com/pg-stat-monitor/) — 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.](https://github.com/percona/pg_stat_monitor) Percona [Pigsty v3.0: An Extension-Rich Postgres Distribution](https://pigsty.io/blog/releases/v3.0.0/) — [Pigsty](https://pigsty.io/) 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. Ruohang Feng [pg_hint_plan 1.7: Tweak Query Execution Plans with 'Hints'](https://github.com/ossc-db/pg_hint_plan) — 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.](https://github.com/ossc-db/pg_hint_plan/blob/master/docs/hint_table.md#types-of-hints) With v1.7, Postgres 17 support has been added. NTT OSS Center DBMS Development and Support Team 📰 Classifieds Indexing dragging you down? Sign up for Redgate’s 10 September webinar, [PostgreSQL 101: Indexing](https://www.red-gate.com/hub/events/postgresql-101-indexing?utm_source=postgresweekly&utm_medium=email&utm_campaign=mc-202409-t2-sodl-ubi-xdb-gc-all%20), to learn tips, tricks, and best practices. --- [Blacksmith](https://blacksmith.sh/?utm_source=cooperpress&utm_medium=classified&utm_campaign=aug-30&utm_term=postgres) runs GitHub Actions up to 2x faster at half the cost with a one-line change. Trusted by 100+ companies like Ashby and Slope. [PgCat 1.2: Modern Postgres Pooler and Proxy](https://github.com/postgresml/pgcat) — Built in Rust, PgCat offers support for sharding (including, experimentally, based upon SQL syntax), load balancing and failover support. PostgresML [`pg_easy_replicate` Now Supports Schema Change Tracking During Logical Replication](https://www.shayon.dev/post/2024/244/pg_easy_replicate-supports-schema-change-tracking-during-logical-replication/) — [pg_easy_replicate](https://github.com/shayonj/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. Shayon Mukherjee - [Patroni 4.0](https://patroni.readthedocs.io/en/latest/) – Popular template for PostgreSQL HA. - [FerretDB 1.24](https://github.com/FerretDB/FerretDB) – A database that acts like MongoDB but uses Postgres for storage. - [PgParty 1.8](https://github.com/rkrage/pg_party) – Create Postgres partitions from Active Record in Ruby. - [DBeaver 24.2](https://dbeaver.io/) – Cross-platform database GUI tool and SQL client. - [pg_failover_slots 1.1](https://github.com/EnterpriseDB/pg_failover_slots) **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|*).