--- title: "Partition pruning without the partition key" publication: "Postgres Weekly" issue: 657 published_at: "2026-07-15" canonical_url: "https://postgresweekly.com/issues/657" --- Plus 30 years of open source Postgres, The Art of PostgreSQL's 2026 update, and a transpiler for stored functions. #​657 β€” July 15, 2026 [Web Version](https://postgresweekly.com/issues/657) Together with [![ParadeDB\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_1280,h_164/e_make_transparent/co_white,e_outline:17/cdd8ciarsq6m8xam8oc3.png)](https://paradedb.com/?utm_source=pgweekly) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/kaeijwub8qefrcin2rpn.jpg)](https://malisper.me/the-four-horsemen-behind-thousands-of-postgres-outages/) [The Four Horsemen Behind Thousands of Postgres Outages](https://malisper.me/the-four-horsemen-behind-thousands-of-postgres-outages/) β€” Two weeks ago we mentioned [pgrust](https://github.com/malisper/pgrust), an AI-assisted rewrite of Postgres in Rust (which now passes 100% of Postgres's regression tests). Here, its creator outlines the biggest Postgres pain points he set out to conquer with the rewrite. Michael Malis πŸ—£οΈ In the meantime, [Hacker News discovered `pgrust`](https://news.ycombinator.com/item?id=48841676) and discussed it at length, with Michael answering numerous questions about its creation and goals. [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/20c8955d.png)](https://paradedb.com/?utm_source=pgweekly) [Search Without a Second System](https://paradedb.com/?utm_source=pgweekly) β€” One Postgres for your application data, full-text search, vector retrieval, and aggregations. ParadeDB is an open-source Postgres extension that keeps pace with Elasticsearch. ParadeDB sponsor [How to Achieve Pruning When Querying by Non-Partitioned Columns](https://hakibenita.com/postgresql-partition-pruning) β€” If a non-partition key column correlates strongly with your partition key (e.g. sequential session IDs in time-partitioned data), `CHECK` constraints can enable pruning on that column too. Includes a BRIN-inspired approach for handling outlier values. Haki Benita **IN BRIEF:** - πŸŽ‚ [Pigsty](https://pigsty.io/) creator Ruohang Feng [celebrates Postgres's 30th birthday](https://vonng.com/en/pg/happy-30-birthday/) based on the first public Postgres CVS server going live on July 8, 1996. - πŸ“˜ Dimitri Fontaine's [_The Art of PostgreSQL_ book](https://theartofpostgresql.com/book/updates/) has been updated for 2026, a significant update that _"modernises the text from PostgreSQL 11 to the 17/18 landscape"_. - 🏴󠁧󠁒󠁳󠁣󠁴󠁿 Jimmy Angelakos shares [a summary of the recent PostgresEDI meetup](https://vyruss.org/blog/postgresedi-july-2026-meetup-public-speaking-ai-compliance.html) in Edinburgh, Scotland, and an invitation to [join the next one](https://cloomba.com/e/postgresql-edinburgh-meetup-aug-2026) on August 13. - The Google Cloud team shares [an update on its recent participation](https://opensource.googleblog.com/2026/07/google-cloud-postgresql-community-contribution-updates.html) at several Postgres events. [How SQL/PGQ Rewrites to Joins on Postgres 19](https://www.cybertec-postgresql.com/en/how-sql-pgq-rewrites-to-joins-on-postgresql-19/) β€” Behind the scenes of Postgres 19's support for [graph queries](https://www.cybertec-postgresql.com/en/handling-graphs-with-sql-pgq-in-postgresql/) and how the graph query syntax compiles down to plain joins. Hans-JΓΌrgen SchΓΆnig β–Ά[Fixing Bad SQL in Postgres with Jimmy Angelakos](https://www.youtube.com/watch?v=SxIgD1OfU_A) β€” A 55-minute talk of concise explanations of common SQL anti-patterns paired with live `psql` demos. Jimmy Angelakos πŸ“„ [The Version Number is Not the Territory](https://thebuild.com/blog/the-version-number-is-not-the-territory/) – A story of a server claiming to be Postgres 14 outputting an error Postgres 14 doesn't even have. Christophe Pettus πŸ“„ [Waiting for Postgres 20: `min()` and `max()` Aggregate Support for `uuid`](https://www.depesz.com/2026/07/09/waiting-for-postgresql-20-add-min-and-max-aggregate-support-for-uuid/) Hubert depesz Lubaczewski πŸ“„ [`COUNT(*)` After a `JOIN` Counts Rows, Not Things](https://theartofpostgresql.com/yesql/sql-foundations/sql-and-ai-count/) Dimitri Fontaine πŸ“„ [How We Scale PgBouncer in ClickHouse Managed Postgres](https://clickhouse.com/blog/pgbouncer-clickhouse-managed-postgres) Kaushik Iska (ClickHouse) πŸ“° Classifieds You already run Postgres. [TimescaleDB extends it for time-series](https://www.tigerdata.com/go/trial?utm_source=content-syndication&utm_medium=referral&utm_campaign=postgres-weekly-newsletter): hypertables, native columnar compression, faster queries. --- πŸ” [Spock](https://github.com/pgEdge/spock): Open-source multi-master Postgres replication w/ active-active writes, conflict resolution, logical slot failover. --- 🐘 [PostgreSQL 19 preview](https://www.enterprisedb.com/blog/jumping-gun-looking-ahead-postgresql-19?utm_source=newsletter&utm_medium=email&utm_campaign=vp_ww_vcop_postgres-newsletter-tgen-20260715): PGQ graph workloads, REPACK CONCURRENTLY, pg_plan_advice & more. EDB hackers on what's coming this fall. **RELEASES AND CODE:** [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/fcelvvlazbal99bf5wap.jpg)](https://github.com/commandprompt/plx) [plx: Write Stored Functions in PHP, JavaScript, Python, and More](https://github.com/commandprompt/plx) β€” Hot on the heels of last week's [PL/Ruby](https://github.com/commandprompt/plruby) comes a more general extension that transpiles JavaScript, PHP, Python, Ruby and even _COBOL_ to PL/pgSQL! Command Prompt Inc. [pg_re2: Fast, RE2-Powered Regular Expressions in Postgres](https://clickhouse.com/blog/introducing-pg_re2-regex-in-postgres) β€” Google's [re2](https://github.com/google/re2) offers more predictable execution time on regexes than the traditional backtracking approach. ClickHouse shows off its use in Postgres here. David Wheeler and Philip DubΓ© [`@neon/sdk`: Neon's New TypeScript Client Library](https://neon.com/blog/neon-sdk) β€” For [Neon](https://neon.com/) users who want to work with the Postgres platform's specific features to manage projects, branches, and databases. Andre Landgraf (Neon) [pgsavvy: A Vim-Style TUI for Working With Databases](https://github.com/davesavic/pgsavvy) β€” A Go-powered TUI app for browsing and querying Postgres databases from the terminal, complete with Vim-style navigation, SQL completions, and interactive `EXPLAIN` plan navigation. Dave Savic - [Pigsty 4.4](https://github.com/pgsty/pigsty/releases/tag/v4.4.0) – An "everything but the kitchen sink" Postgres distribution that's now based on Postgres 18.4, with a Postgres 19 beta template available to try. Now includes 531 extensions ready to go. - [plpgsql_check 2.10](https://github.com/okbob/plpgsql_check) – PL/pgSQL linter that uses Postgres's own parser/evaluator to detect errors and improve code quality. - [pgCodeKeeper 15.0](https://pgcodekeeper.org/) – Java-powered Eclipse IDE plugin to diff database schemas and generate migration scripts. - [PostgREST 14.15](https://github.com/PostgREST/postgrest) – Serve a fully RESTful API from any Postgres database. **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|*).