Home / Companies / ClickHouse / Blog / Post Details
Content Deep Dive

What's New in pg_clickhouse v0.3.2: Postgres 19, TLS, Regex, and Memory

Blog post from ClickHouse

Post Details
Company
Date Published
Author
Postgres 19 #
Word Count
535
Company Posts That Month
82
Language
English
Hacker News Points
-
Summary

Last week's release of pg_clickhouse v0.3.2 brings significant improvements to the interface for querying ClickHouse from Postgres, despite being a minor update. It introduces support for PostgreSQL 19 Beta1, allowing for better optimizations and preparation for the final release. Enhancements in TLS connections now offer more secure and flexible connection options, thanks to contributions from Andrey Borodin. The update also fixes errors in regular expression pushdown logic, improving compatibility between Postgres and ClickHouse. Additionally, it addresses memory consumption issues identified in certain customer queries, particularly in nested-loop joins and unbuffered queries with the HTTP driver, and introduces new CREATE SERVER options like compression to streamline data handling. With these updates, the pg_clickhouse and ClickHouse Cloud combination continues to establish itself as a robust unified data stack for scalable applications.

Trends Found in this Post

No tracked trend matches for this post yet.