PostgreSQL 19 and PHP 8.6 land on the same day with REPACK, pg_plan_advice and partial function application

On Thursday, November 19, 2026, two of the most widely used open-source projects on the web shipped major releases on the same day: PostgreSQL 19, from the PostgreSQL Global Development Group, and PHP 8.6, from the PHP development team. It is a rare day for people who build the web — database and language arriving together, with changes that reach from table maintenance to how functions are written.

PostgreSQL 19: non-blocking REPACK and more planner control

The headline feature of PostgreSQL 19 is the new REPACK command, which reclaims disk space and reorganizes a table's contents — and, with REPACK (CONCURRENTLY), does so without blocking reads and writes. Until now, the equivalent job required VACUUM FULL or CLUSTER, which blocked access to the table while the cleanup ran.

The release also gives users more control over the query planner: the new pg_plan_advice extension lets you pin and experiment with plan decisions, and the companion pg_stash_advice extension stores that advice and applies it automatically to queries with the same identifier — so a slow plan can be fixed without changing application code.

Other new features include autovacuum with parallel workers for indexes and a new scoring system to prioritize tables; logical replication without a server restart when wal_level is set to replica; replication of sequence values; and the WAIT FOR LSN command, which brings "read-your-writes" consistency to standbys. For developers, there is also INSERT ... ON CONFLICT DO SELECT and JSON output from COPY.

Anyone upgrading should note one changed default: JIT compilation is now disabled by default. PostgreSQL 19 will receive five years of support, following the project's policy.

PHP 8.6: partial function application and a new polling API

PHP 8.6 is a major update of the language. The most talked-about feature is Partial Function Application: some of a function's arguments can be provided in advance, returning a Closure that accepts the rest, using the ? and ... placeholders — with no need to write an intermediate function.

The release also adds the new \Time\Duration class, which represents durations with nanosecond precision; the Io\Poll polling API, which uses the best mechanism on each platform (epoll on Linux, kqueue on BSD and macOS, WSAPoll on Windows) as a common foundation for event loop libraries such as ReactPHP and AMPHP; the clamp() function, which keeps a value within a range; the SortDirection enum; and default values for readonly properties.

PHP 8.6 follows the language's annual release cadence, with two years of active support and two years of security support.

Sources

Featured image: the PostgreSQL logo (blue elephant), by Daniel Lundin, under the PostgreSQL License, via Wikimedia Commons.

Transparency: this article was produced with the assistance of artificial intelligence, drawing on public posts on X and sources from the internet. Always consult the original sources to confirm the information.

By Muse