Pg_ClickHouse: A Postgres extension for querying ClickHouse
3 days ago
- #Database Migration
- #PostgreSQL
- #ClickHouse
- ClickHouse Cloud users commonly migrate from PostgreSQL, facing challenges with query and application code migration.
- pg_clickhouse v0.1.0 released: a PostgreSQL extension to execute analytics queries on ClickHouse transparently.
- Goals include ClickHouse query execution from PostgreSQL, unmodified existing queries, and query pushdown to ClickHouse.
- Improvements over clickhouse_fdw: modernized code, added test cases, TLS support, and advanced pushdown features.
- Aggregate pushdown feature converts PostgreSQL functions like percentile_cont to ClickHouse's quantile function.
- SEMI JOIN pushdown significantly improves performance for analytical queries, as shown in TPC-H benchmark results.
- Future roadmap includes more pushdown coverage, support for all PostgreSQL functions, and DML features.