Level: Intermediate
The dream of HTAP — Hybrid Transactional and Analytical Processing — promised a unified system that could power both real-time applications and large-scale analytics. But the promise remains largely unfulfilled. As existing systems forced a compromise — delivering OLTP and OLAP that were both suboptimal. - We just want postgres for OLTP.
This talk introduces a new architecture for HTAP — one that doesn’t compromise either side. We’ll explore how decoupling OLTP and OLAP, and yet providing a sub-second transactionally consistent link between them, might be the right way to finally achieve the HTAP dream.
And how we do it all with in postgres extension system, with pg_mooncake.