pg_clickhouse v0.3.2 ships with four key improvements: PostgreSQL 19 Beta1 support (with minor source code revisions for tuple/array optimizations), new TLS connection options (`secure` and `min_tls_version`) for `CREATE SERVER`, fixes to regex flag pushdown logic between Postgres and ClickHouse, and memory consumption fixes for unbuffered HTTP queries and nested-loop join re-scans. Additional changes include a `compression` option for native protocol compression, improved `regexp_match()` pushdown, and a bug fix for `ANY()` with empty arrays on older ClickHouse versions. The update requires no restart or extension reload.

3m read timeFrom clickhouse.com
Post cover image
Table of contents
Postgres 19 #TLS connections #Regular expressions #Memory consumption #And more #
35.1K Impressions1 Comment