The PostgreSQL Global Development Group released PostgreSQL 19 on November 19. The new version focuses on day-to-day operations: cleaning up tables without downtime, controlling query plans and simplifying replication.

REPACK without blocking

The headline feature is REPACK (CONCURRENTLY). It reclaims space from bloated tables and can reorder table data without blocking reads or writes. It is designed to replace VACUUM FULL and CLUSTER, which remain available for compatibility. For busy databases, removing bloat without a maintenance window is a major improvement.

Plan advice for problem queries

A new pg_plan_advice extension lets administrators pin choices in a query plan, and pg_stash_advice can apply that advice automatically by query ID. In practice, this means a slow query plan can be fixed without changing the application code.

Maintenance and monitoring

Autovacuum can now use parallel workers for indexes and uses a new scoring system to decide which tables to process first. New statistics views, including pg_stat_lock, pg_stat_recovery and pg_stat_autovacuum_scores, make it easier to see what the database is doing.

Replication improvements

Enabling logical replication no longer requires a server restart. Publications can include all sequences and use a new EXCEPT clause. WAIT FOR LSN gives applications read-your-writes consistency when reading from standby servers.

SQL and performance

New SQL features include INSERT … ON CONFLICT DO SELECT for simple “get or create” patterns, JSON output for COPY and IGNORE NULLS for window functions such as lead() and lag(). The project says foreign key checks are faster, with bulk inserts nearly twice as fast in testing. The planner can turn NOT IN into anti-joins and aggregate before joins.

Defaults and security changes

JIT compilation is now off by default because its cost estimates proved unreliable. LZ4 becomes the default compression for large values when available. Logins using md5 passwords now produce deprecation warnings, and RADIUS authentication has been removed. Check these changes before upgrading, especially if you still rely on md5 or RADIUS.

Upgrade advice

As with every major version, test your applications, extensions and backup procedures before moving production systems, and read the full release notes for compatibility changes.

Sources:

Decoding the Lifespan of Computer RAMpc

Decoding the Lifespan of Computer RAM

numan permusŞubat 15, 2024
Need a numpad? Add this wireless one to your laptop for just $30pc

Need a numpad? Add this wireless one to your laptop for just $30

permusTemmuz 26, 2024
Never pay full price for Amazon purchases again with this free siteamazon

Never pay full price for Amazon purchases again with this free site

permusMart 17, 2025