Data Engineering·12 min read·2,394 words

Lakebase LTAP Explained: How Databricks Is Merging OLTP and OLAP in 2026

Databricks announced LTAP in June 2026, a new architecture that runs transactional and analytical workloads on a single copy of data. This is a technical breakdown of how Lakebase and LTAP actually work, what problem they solve, and where the skepticism from competitors comes from.

Krunal Kanojiya

Krunal Kanojiya

Share:
#data-engineering#databricks#lakebase#ltap#olap#oltp#postgres#unity-catalog
Lakebase LTAP Explained: How Databricks Is Merging OLTP and OLAP in 2026

Every few years a database vendor announces they have solved the transactional versus analytical divide, and every few years the announcement turns out to mean something more modest than the headline. Databricks made that exact announcement in June 2026 with LTAP, so it is worth being precise about what is actually new here versus what is repackaged marketing.

I read through the architecture posts, the press coverage, and the pushback from competitors before writing this. The short answer is that Lakebase and LTAP are doing something technically real, even if the framing around "one copy of data" invites more scrutiny than Databricks' launch materials suggest. This article breaks down how it actually works.

The Short Version

If you want to skip ahead, here is the summary.

Lakebase is Databricks' serverless Postgres database. It separates the write ahead log and data files from the compute layer, which gives you elastic scaling, instant branching, and scale to zero.

LTAP builds on top of Lakebase by writing that same operational data directly into open columnar formats in Unity Catalog, so analytical engines can query fresh transactional data without a CDC pipeline or a second copy.

If your team runs Postgres alongside a separate analytics pipeline and the sync lag between them causes real problems, this is worth understanding closely. For everything else, keep reading.

Why This Announcement Exists

For four decades, operational databases and analytical systems have lived apart. An application writes an order into Postgres or MySQL. A data engineering team captures that change through CDC, lands it in a warehouse or lake, transforms it through several pipeline stages, and eventually makes it available for dashboards or machine learning.

That pattern works, but it has a cost. The pipeline is another system to maintain, the data in the two places is never perfectly in sync, and permissions have to be managed twice. Databricks CEO Ali Ghodsi has pointed to a newer pressure on top of the old problem: AI agents create, query, and discard databases far faster than human developers ever did, and a pipeline with hours of lag does not fit that pattern.

LTAP is Databricks' answer to both problems at once. Rather than building a faster pipeline, it tries to remove the need for one.

The Foundation Underneath Lakebase

Lakebase did not appear out of nowhere. It is built on technology from Neon, a serverless Postgres company Databricks acquired for roughly one billion dollars. Neon's core idea was separating Postgres compute from storage, and Databricks extended that idea to plug directly into the Lakehouse.

To understand what changed, it helps to know how a normal, single-machine Postgres deployment works. Two things on disk matter most: the write ahead log, which records every change before it is applied, and the data files, which hold the actual table pages. In a standard deployment, both live on the same local disk as the database engine.

Lakebase pulls both of those pieces out into independent, externally managed services.

What the SafeKeeper Service Does

The write ahead log moves to a distributed service Databricks calls the SafeKeeper. Instead of a commit becoming durable by flushing to local disk, a commit becomes durable when the log record is replicated across a quorum of SafeKeeper nodes using Paxos-based consensus.

This might sound like it should add latency, since you are now making a network round trip instead of a local disk write. In practice it does not, for a subtle reason: any production Postgres deployment that cares about durability already uses synchronous replication, which requires a network round trip regardless. Externalizing the log to SafeKeeper does not add a new cost on top of what a serious deployment already pays.

What the PageServer Service Does

The data files move to a second distributed service called the PageServer. It streams the WAL from SafeKeeper and asynchronously reconstructs data pages, materializing them into low-cost cloud object storage rather than a local file system.

When your Postgres compute needs to read a page, it first checks a local cache, then falls back to the PageServer, which reconstructs the page from the most recent base image plus any subsequent WAL deltas. Databricks published a deeper optimization here in 2026: rather than generating full page images on a fixed checkpoint schedule, the PageServer generates them based on how many changes have accumulated on a given page. In their own benchmarks using a TPC-C derived workload, this dropped average WAL traffic per transaction from 58KB to under 4KB, a 94 percent reduction, and pushed write throughput up by more than 4.5x on larger compute instances.

Because compute no longer owns any durable state, it becomes disposable. You can stop it, restart it, or scale it to zero, and as long as it can reach SafeKeeper and PageServer, it resumes exactly where it left off. This is also what makes instant, copy-on-write database branching possible: creating a branch is a metadata operation against a specific point in the WAL, not a physical copy of any data.

Where LTAP Picks Up From Here

Everything described so far makes Lakebase a better operational Postgres. LTAP is a separate layer that uses this same architecture to solve the transactional-versus-analytical divide.

Even with Lakebase's externalized storage, the data materialized by the PageServer was still written in Postgres's native row-oriented page format. That format is well suited to transactions and poorly suited to analytics. Any analytical engine that wanted to read it had to either pay a conversion cost on every query or, more commonly, rely on a separately maintained copy kept in sync by CDC.

LTAP removes that second copy. Lakebase now writes operational data directly into open columnar formats, specifically Delta Lake and Iceberg, registered in Unity Catalog alongside the rest of your Lakehouse data. The moment data lands in the PageServer's materialization step, which already had to happen for Lakebase to work, is the same moment it becomes available in a format the Lakehouse engines can query natively.

The practical result: transactional workloads keep running in standard Postgres with full ACID guarantees, and analytical workloads run against the Lakehouse at whatever scale you need, both reading from a single governed copy of data with no ETL step connecting them.

The Distinction Databricks Draws With HTAP

Databricks is careful to separate LTAP from HTAP, and the distinction is worth understanding because it is the core of their technical argument.

HTAP, Hybrid Transactional/Analytical Processing, is an older category of database that tries to handle both workload types inside a single engine. Systems like SAP HANA and SingleStore fall into this category. The appeal is obvious: one engine, one system to operate. The problem is that transactional workloads and analytical workloads want opposite things from a storage engine. Transactions want fast row-level reads and writes. Analytics wants fast column-level scans across millions of rows. Building one engine that is excellent at both has proven difficult across four decades of attempts.

LTAP does not try to build that single engine. It keeps Postgres for transactions and Lakehouse engines for analytics as two separate systems, each optimized for its own job. What LTAP unifies is the storage layer underneath both of them. Same governed data, same Unity Catalog permissions model, two different engines reading it in the way each one prefers.

Whether this framing survives contact with production reality is a fair question, and not everyone is convinced.

Why Some Competitors Are Skeptical of the Framing

Not every technical observer accepts Databricks' framing at face value, and the pushback is worth knowing before you repeat the marketing claims to your own team.

SingleStore's CTO published a public response arguing that unifying OLTP and OLAP so an agent can read and write from one place was always the goal of HTAP, and that renaming the approach does not change the underlying physics. The core of the critique is that LTAP still runs three separate engines on top of the storage layer, each with its own cache and its own notion of data freshness, and that a shared storage format is not the same thing as a shared query engine.

A separate piece of reporting pressed Databricks on the "one copy of data" language directly. A Databricks spokesperson clarified that the "one copy" claim refers specifically to the durable, governed source of truth in Iceberg format, not to the various caches, in-memory buffers, and materialized page representations that necessarily exist at different layers of any database system, LTAP included.

Neither of these critiques argues that LTAP does nothing useful. They argue that the "zero copies" pitch oversimplifies what is still, underneath, a system with meaningful caching and format-conversion machinery at multiple layers. Both things can be true: the CDC pipeline is genuinely gone, and there is still more internal complexity than a two-word slogan implies.

How This Compares to Snowflake's pg_lake Approach

Databricks is not the only company shipping a "Postgres plus Lakehouse" story in 2026. Snowflake has pg_lake, a set of open source Postgres extensions plus a managed service, and it is worth knowing the two are solving the problem from opposite directions.

pg_lake keeps standard Postgres exactly as it is and adds an access layer that lets it read and write Lakehouse table formats from within normal Postgres. Your storage engine does not change. Lakebase does the opposite: the Postgres SQL surface stays familiar, but the entire storage subsystem underneath it is replaced with SafeKeeper, PageServer, and object storage. One approach extends Postgres outward toward the lake. The other rebuilds Postgres's insides to already be lake-shaped.

Which one fits your situation depends on details neither vendor's marketing addresses directly: how much you value keeping an unmodified, portable Postgres deployment versus how much you value native branching, scale-to-zero, and page-level integration with the Lakehouse. Teams already committed to the Databricks platform have less reason to weigh this trade-off, since Lakebase is bundled into the ecosystem they are already using.

Real Numbers From Databricks' Own Benchmarks

A few concrete figures are worth pulling out separately from the architecture description, since they are the closest thing to independently checkable claims in the announcement.

Lakebase already serves thousands of customers as of mid-2026, including Block, Superhuman, and Zillow, and Databricks reports 12 million database launches per day across the platform, a figure that reflects how cheap it is to spin up a Lakebase instance for a short-lived agent task compared to a traditional managed Postgres offering.

On raw Postgres performance, Databricks' own HammerDB TPC-C benchmarks show write throughput improving by roughly 4.5x on 32 vCPU compute instances after the PageServer's image generation pushdown optimization, alongside a 2x reduction in read tail latency. These are internal, vendor-reported numbers rather than independently audited ones, so treat them as a starting point for your own testing rather than a guarantee for your workload.

Lakehouse//RT, the real-time analytics engine Databricks paired with the LTAP announcement, claims response times as low as 10 milliseconds for small workloads and under 100 milliseconds for larger ones, with customer reports of up to 16x improvement over prior real-time serving setups. Again, vendor-reported, and worth validating against your own query patterns before committing.

What LTAP Means for a Data Engineering Team

Setting the marketing language aside, there are a few concrete situations where this architecture is worth paying attention to.

You are maintaining a CDC pipeline whose main job is keeping a warehouse copy in sync with an operational Postgres database. If that pipeline is a meaningful source of operational overhead or the sync lag causes real product problems, LTAP is directly aimed at replacing exactly that pipeline.

You are building AI agents that need to read and write operational data quickly. The scale-to-zero and instant branching properties of Lakebase matter more for this use case than the LTAP analytics story does, since agents spinning up throwaway database instances benefit directly from cheap, disposable compute.

You already run Databricks and want a Postgres-compatible transactional layer inside the same governance model. If Unity Catalog already governs your Lakehouse data, extending that same identity and permissions model to your operational database is a real simplification, independent of how the LTAP marketing lands.

If none of these describe your situation, this is worth knowing about and revisiting in a year rather than something to act on immediately. Architecture announcements at this scale typically take a few release cycles to mature past the flagship customer examples into something a mid-sized team would reach for by default.

One detail that did not get much coverage outside Databricks' own blog is Lakebase Search, a retrieval layer built directly into Lakebase Postgres using the same tiered storage architecture. It combines standard pgvector for dense retrieval with a custom BM25-based extension for keyword search, fused with reciprocal rank fusion, all inside a single SQL query against the same transactional tables an application already writes to.

This matters if your application already stores vectors alongside operational data. Instead of maintaining pgvector on a conventional Postgres instance and hitting the scale ceiling covered in the pgvector vs Pinecone comparison, Lakebase Search pushes the cold tail of a vector index into cheap object storage while keeping the hot working set on local NVMe cache, which is the same tiered pattern that makes the rest of Lakebase economical at scale.

Getting Started if You Want to Try It

Lakebase is available today as part of the Databricks platform with a 14 day free trial, and it can be registered as a catalog in Unity Catalog to work with Lakehouse Federation. LTAP itself is described by Databricks as rolling out as an extension of Lakebase over the following months rather than being universally available on day one, so check current availability for your cloud and region before planning around it.

If your team is evaluating this, the most useful first step is not reading more marketing material. Point a non-critical workload at a Lakebase branch, run your actual query patterns against it, and compare the branching and scale-to-zero behavior against whatever your current Postgres setup costs you in provisioning time and idle compute.

Frequently Asked Questions

What is LTAP in Databricks?

LTAP stands for Lake Transactional/Analytical Processing. It is a Databricks architecture, announced in June 2026, that stores operational data once in open columnar formats such as Delta Lake and Iceberg so both Postgres and Lakehouse analytical engines can read the same copy of data without a CDC pipeline or a second copy.

What is the difference between Lakebase and LTAP?

Lakebase is the serverless Postgres database itself, built by externalizing the write ahead log and data files into separate cloud services. LTAP is the layer built on top of Lakebase that writes that same operational data directly into open columnar formats in Unity Catalog, making it queryable by Lakehouse analytical engines without any data movement.

Is Databricks LTAP the same as HTAP?

No. HTAP tries to handle both transactional and analytical workloads inside a single database engine. LTAP keeps two separate engines, Postgres for transactions and Lakehouse engines for analytics, but unifies them at the storage layer so both engines read the same underlying files. Databricks frames this as a deliberate departure from the HTAP approach, which has struggled for decades to deliver both workloads well in one engine.

How much does Databricks Lakebase cost?

Lakebase uses consumption based pricing where you pay for compute and storage separately, with compute scaling to zero when idle. Databricks offers a 14 day free trial, and committed use discounts are available for larger deployments. Exact rates depend on cloud provider and region, so check the official Lakebase pricing page for current numbers.

Can I use Lakebase without the rest of Databricks?

Lakebase is sold as part of the Databricks platform and is tied to Unity Catalog for governance and identity. You cannot run it as a fully standalone product the way you would with a self-hosted Postgres instance. If you want the underlying open source technology, Neon, which Databricks acquired and built Lakebase on, is available separately.

Is Lakebase just a hosted version of Postgres?

The SQL surface is standard Postgres and your existing drivers, libraries, and queries work unchanged. Underneath, the storage engine is completely different. The write ahead log goes to a distributed SafeKeeper service instead of local disk, and data pages are reconstructed on demand by a PageServer that materializes them into cloud object storage rather than a local file system.

Follow on Google

Add as a preferred source in Search & Discover

Add as preferred source
Appears in Google Discover
Krunal Kanojiya

Krunal Kanojiya

Technical Content Writer

I am a technical writer and former software developer from India. I publish practical tutorials and in-depth guides on AI engineering, data engineering, programming, algorithms, blockchain, and modern software development.