PostgreSQL 19 graph queries fail the 'would you ship this?' test
SQL/PGQ gets bounced over unresolved bugs as concurrent REPACK promises fewer midnight calls for DBAs
PostgreSQL developers have removed planned graph query support from version 19 due to concerns about unresolved bugs that could impact the release. The feature, known as SQL Property Graph Queries (SQL/PGQ), was part of the SQL standard since 2023 and allows for exploring relationships between nodes connected by edges. PostgreSQL's implementation of this feature has been removed, with the fourth beta scheduled for September 24.
However, a new command called REPACK offers a CONCURRENTLY option that allows other transactions to access the table during most of the operation, minimizing the need for administrators to run VACUUM FULL, which can cause unexpected interruptions and calls from customers.
Written by urgent.news from The Register's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.
This story
This is one outlet's version. Read the fullest account.
- PostgreSQL 19 graph queries fail the 'would you ship this?' test theregister.com
