2 ms·
How does mooncake work with std oltp workloads? Can I use Postgres with OLTP , add mooncake and expect duckdb-level of performance for OLAP queries? I know that
by polskibus 2y ago
How does mooncake work with std oltp workloads? Can I use Postgres with OLTP , add mooncake and expect duckdb-level of performance for OLAP queries?
I know that SAP HANA has some sort of several layers of storage and automatic movement of data between them to allow for such performant OLTP/OLAP hybrid, and I think this is the holy grail for cheap/open source db. Users need OLTP first but don’t want to add Kafka + clickhouse or similar pipelines when OLAP is needed.
- moonikakiss 2y agoIn v0.2, this is exactly what we're building. Keep your OLTP as it. Deploy Mooncake with logical replication into columnstore tables, and get DuckDB like perf. A big part of this is not replacing your OLTP.