NEWThe field notebook is live: limits, limits and links for 8 browser capabilities.Read the notes →
useful tomorrow®
Field notesStatus

PostgreSQL 19 Beta 4 drops SQL/PGQ, online checksums, temporal tables

The beta pulls five planned features, a signal that on-call teams should recheck their upgrade test plans now rather than at release.

PostgreSQL 19 Beta 4 shipped on September 24, 2026, and the release notes list a set of reverts: SQL/PGQ, the online checksum toggle, temporal FOR PORTION OF, MERGE/SPLIT PARTITIONS, and several DDL helper functions. The same notes list fixes to REPACK, WAIT FOR, and replication. Betas exist to catch exactly this kind of problem before a major version locks in, so a revert this late in the cycle is not alarming by itself. What matters is which of these features already showed up in a staging plan or a migration script written against earlier beta documentation.

Each dropped feature maps to a specific kind of operational work. SQL/PGQ touches graph-style queries. The online checksum toggle touches how a running cluster enables checksums without a restart. Temporal FOR PORTION OF and MERGE/SPLIT PARTITIONS touch schema and partition management, the kind of DDL that gets scripted into migration tooling ahead of a major-version cutover. If any of these appeared in a runbook, that runbook now describes a feature that will not exist in 19.0 as released. The announcement does not say why each item was reverted, and it does not give a timeline for when, or whether, any of them return in a later version.

That gap is the part on-call teams need to sit with. The announcement confirms the reverts happened and confirms the REPACK, WAIT FOR, and replication fixes landed in the same beta. It does not confirm a root cause for the reverts, and it does not confirm whether the feature removal affects on-disk format, upgrade paths from 18, or only documentation and surface syntax. Treat the confirmed list as a change log, not a postmortem. Anything about stability risk in the reverted code paths is inference, not something stated in the release.

For teams running staging environments against PostgreSQL 19 betas, the checklist is short. Check whether any pipeline references SQL/PGQ syntax. Check whether schema migration tooling calls MERGE PARTITIONS or SPLIT PARTITIONS. Check whether a runbook assumes the online checksum toggle as a zero-downtime path to enabling checksums on a live cluster, since that path no longer exists in this beta. None of this requires action if 19 is not yet in any pipeline. It requires action if a migration script, CI job, or internal doc already assumes one of the five reverted items will ship.

Replication and REPACK behavior deserves separate attention, since those are the areas the announcement says were fixed rather than removed. A fix to replication logic in a beta is routine, but it is also the kind of change that can shift timing in logical replication setups that were tuned against Beta 3. Anyone running replication against an earlier 19 beta should re-test failover and lag behavior against Beta 4 specifically, not assume parity. The announcement does not quantify the replication fix or name the bug it addresses.

Nothing here is a production incident. PostgreSQL 19 is still in beta, and the reverts are the kind of narrowing that happens before a major release freezes. The concrete fact for any on-call queue is simpler: five named features are gone from Beta 4, three subsystems got fixes, and the next checkpoint is whatever ships in Beta 5 or the release notes for 19.0.

Primary references

Useful Tomorrow · StatusUpdated September 28, 2026