Viewing profile — zhousun

author here. I would actually second you. My core belief is "it is possible to build true database-like functionalities on top of iceberg", but it is definitely not 'easier' than b…

there's actually a great read, cursor started with a distributed OLTP solution: yugabyte, and then fall back to RDS...

Using SQL as catalog is not new (iceberg supports JDBC catalog from the very beginning). The main difference is to store metadata and stats also directly in SQL databases, which ma…

DataFile(parquet) is not enough for table with update/delete, (they are part of iceberg "metadata"). for CDC from OLTP use-cases, the pattern involves rapidly marking rows as delet…

Glab to see more 'postgres-native' full-text search implementation. Alternative solutions (lucene/ tantivy) are both designed for 'immutable segments' (indexing immutable files), s…

lol spot-on comment and stay tuned for our v2 :) The focus of mooncake is to be a columnar storage engine, that natively integrate with pg, allowing writing from pg, replicating fr…

Yep what I want say is the line between the two designs is indeed very blur. Logical replication with mooncake will try to create a columnar version of a postgres heap table, that …

Yea this is indeed a repeated pattern we saw people requesting (filter on many columns) and we are trying to solve with pg_mooncake. If you are interested, feel free to join moonca…

people tried to run spark (better hadoop) and failed lol. https://github.com/ClickHouse/ClickBench/pull/139

Thanks for the comment but you are mixing some terminologies. The core idea of mooncake is to built upon open columnar format + substitutable vectorized engine, while natively inte…

hydra/pg_duckdb embeds duckdb to query existing data on S3. So it is kind of targeting a completely different use case (someone already prepares and shared a dataset and you just w…

zhou from mooncake labs here. Good point! Normally for postgres extension it won't be solvable, but for mooncake it is actually not the case! The core idea of mooncake is to built …

transactions are also managed by postgres as if they are native table, so that you don't need to worry about coordinating commits between postgres and the S3 data.

Interesting enough, the mooncake team was building SingleStore before, and so far it is the best production-ready HTAP system. One lesson I really learned is, people don't want to …

Zhou from mooncake labs here. Mooncake is built upon open-table formats and substitutable query engines. So it don't need to be just a postgres extension. PG_mooncake will stay ope…

Hi, Zhou From Mooncake labs here. Love your work on PeerDB and it's inspiring the evolvement of pg_mooncake (logical replication will be the killing feature for V2) The core idea o…

The only datastack iceberg (or lakehouse) will never replace is OLTP systems, for high-concurrency updates optimistic concurrency control & object store is simply a no go. Iceberg …

It's such an honor our https://pgmooncake.com/ is covered in the review! A little sad Andy didn't share more of his thoughts on the intersection between Data and AI, and how that's…