Artificial intelligence news.
Straight from the original announcements.

PostgreSQL 19 reaches Lakebase on the day of its release

November 19, 2026, 16:31By the AI News Bites Editorial TeamSource: Databricks
PostgreSQL 19 reaches Lakebase on the day of its release
Image: Databricks

PostgreSQL 19 is now available on Databricks’ Lakebase on the same day it reached general availability. Customers can try the release by creating a new Lakebase project and selecting PostgreSQL 19.

Key points
  • PostgreSQL 19 is available on Lakebase at general availability.
  • REPACK can reclaim space while reads and writes continue during most of the operation.
  • pg_plan_advice and pg_stash_advice provide tools for stabilizing query plans.
  • PostgreSQL 19 adds autovacuum, diagnostics and logical replication improvements.
  • Users can select PostgreSQL 19 when creating a new Lakebase project.

A release focused on operational control

According to Databricks, PostgreSQL 19 targets day-to-day problems faced by database teams, including bloated tables, unstable query plans, replica lag, incomplete statistics and maintenance work that can be difficult to run safely in production.

The release does not center on one feature that changes PostgreSQL’s basic design. Instead, it adds more ways for teams to intervene when default behavior is not sufficient, while retaining the project’s focus on reliability and predictable behavior.

Databricks said several Lakebase engineers are PostgreSQL committers and contributors who worked directly on the release. Their work covered areas including query plan advice, shared memory, locale handling and release management.

REPACK reduces the need for maintenance downtime

PostgreSQL 19 adds REPACK, which can reclaim table space while normal reads and writes continue during most of the operation. The feature addresses the bloat that can build up as updates create new row versions and deletes leave dead tuples behind.

With USING INDEX, REPACK can also physically order rows like CLUSTER. With CONCURRENTLY, PostgreSQL rebuilds a table while capturing ongoing changes through logical decoding. It later applies the remaining changes and swaps the new table and index files into place, using an ACCESS EXCLUSIVE lock for that final phase.

Databricks cautions that concurrent repacking requires additional replication-slot capacity, temporary disk space and a suitable primary key or replica identity. Long-running transactions can delay the final lock, and the operation has limits for tables with heavy update and delete activity. Physical clustering can also degrade as later writes arrive.

Plan advice, diagnostics and replication updates

Two new components, pg_plan_advice and pg_stash_advice, let administrators inspect planner decisions, apply targeted advice and store that advice by query ID. Databricks presents this as a way to stabilize a critical query after an inaccurate estimate leads to a poor execution plan. The advice does not replace the planner or prove that a resulting plan is better, so teams still need to evaluate it against their workload.

Other operational changes include parallel workers for index vacuuming, a scoring system for prioritizing autovacuum work and new views covering locks, recovery and autovacuum scores. EXPLAIN can report asynchronous I/O activity and additional WAL information is available through statistics, execution plans and maintenance logs.

Logical replication also gains several capabilities. Logical decoding can be activated without a restart when wal_level is replica, sequence values can be synchronized between publishers and subscribers, and publications can include all sequences or exclude named tables. Subscription changes include reuse of connection details from a postgres_fdw server and options for detecting certain update-delete conflicts.

For Lakebase users, the main implication is immediate access to these PostgreSQL 19 capabilities. Databricks said major PostgreSQL versions can take weeks to reach other managed PostgreSQL services, while Lakebase customers can select the version when creating a new project.

Related news

Databricks Opens Genie ZeroOps to Public Beta for Pipeline Fixes
Products and toolsNovember 19, 2026, 22:30

Databricks Opens Genie ZeroOps to Public Beta for Pipeline Fixes

Databricks has moved Genie ZeroOps into public beta, giving workspace teams an autonomous agent that detects, investigates and helps resolve data pipeline issues. The…

Databricks gives Azure users free Genie access with budget controls
Products and toolsNovember 19, 2026, 19:00

Databricks gives Azure users free Genie access with budget controls

Databricks is giving every identified Azure Databricks user $10 of free Genie usage each month, while adding controls for admins who want to limit spending beyond that…

Databricks Mitigates Java4Shell Vulnerability Before Public Disclosure
Safety and ethicsNovember 19, 2026, 18:00

Databricks Mitigates Java4Shell Vulnerability Before Public Disclosure

Databricks says it had already begun addressing the industry-wide Java4Shell OpenJDK vulnerability, CVE-2026-114938, before its public disclosure. The company has…