7 ms·
This is an attempt to replicate MotherDucks differential storage and implement hybrid query execution on DuckDB
by citguru 5mo ago
This is an attempt to replicate MotherDucks differential storage and implement hybrid query execution on DuckDB
- zurfer 5mo agoAs someone working in the field I have to admit that I'm not familiar with the terms differential storage nor do I really understand what hybrid execution means. Maybe you could describe it both from a simple technical point of view and what benefits it has to me as a user?
- skeeter2020 5mo agofrom the post: Differential storage Append-only layers with PostgreSQL metadata. DuckDB sees a normal file; OpenDuck persists data as immutable sealed layers addressable from object storage. Snapshots give you consistent reads. One serialized write path, many concurrent readers. Hybrid (dual) execution A single query can run partly on your machine and partly on a remote worker. The gateway splits the plan, labels each operator LOCAL or REMOTE, and inserts bridge operators at the boundaries. Only intermediate results cross the wire.