How SQL/PGQ Rewrites to Joins on PostgreSQL 19

Jihoo Park · 2026-07-15T00:19:53+00:00

PostgreSQL 19's SQL/PGQ feature lets you write graph-style queries, but the database rewrites them into ordinary joins and plans them with the regular optimizer. Graph pattern matching in Postgres 19 is really a declarative layer / syntactic layer on top of relational tables, not a separate graph engine. This makes SQL/PGQ easier to adopt on existing schemas, while still tying performance to normal PostgreSQL join behavior and indexes. Learn more: https://www.cybertec-postgresql.com/en/how-sql-pgq-rewrites-to-joins-on-postgresql-19/

From: Jihoo Park | Date: Wed, 15 Jul 2026 00:19:53 +0000 #
Subject: How SQL/PGQ Rewrites to Joins on PostgreSQL 19
PostgreSQL 19's SQL/PGQ feature lets you write graph-style queries, but the database rewrites them into ordinary joins and plans them with the regular optimizer. Graph pattern matching in Postgres 19 is really a declarative layer / syntactic layer on top of relational tables, not a separate graph engine. This makes SQL/PGQ easier to adopt on existing schemas, while still tying performance to normal PostgreSQL join behavior and indexes. Learn more: https://www.cybertec-postgresql.com/en/how-sql-pgq-rewrites-to-joins-on-postgresql-19/
[ Reply ]

[ Back to Group: comp.databases.postgresql ]

Keyboard Shortcuts: [ j/n next | k/p prev | g top | r reply | u up ]