[mathisd]

> No performance tradeoffs, for any workload: Transactional workloads run in standard Postgres with full ACID semantics. Analytical workloads run across the full Lakehouse at any scale and concurrency. Each scales independently, and because there's no data movement between systems, operational and analytical results are always in sync — with no copies or shadow infrastructure.

How can there be no performance trade-off if storage is handled by PostGres and there is no data movement to convert it to columnar ? This deserve a technical explanation because this seems impossible.

[saxenaabhi]

Probably it's based on similar architecture as SAP HANA? With a main store and an in-memory delta store.

https://dl.acm.org/doi/10.1145/2213836.2213946