---
title: "pg_clickhouse 0.3.1: Now With More C"
url: https://daily.dev/posts/pg-clickhouse-0-3-1-now-with-more-c-h3naoiqtg
source_url: https://postgr.es/p/9l8
type: article
source: "Planet PostgreSQL"
published: 2026-06-03T20:32:38.539Z
updated: 2026-06-03T20:32:58.534Z
tags: ["c", "postgresql", "clickhouse"]
reading_time: 2
upvotes: 1
comments: 0
language: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# pg_clickhouse 0.3.1: Now With More C

**[Planet PostgreSQL](https://daily.dev/sources/planet-postgresql)** · 2 min read · 1 upvotes · 0 comments

## Summary

pg_clickhouse 0.3.1 replaces the clickhouse-cpp C++ library with the new clickhouse-c header-only C library written by Philip Dubé. Key benefits include eliminating C++ exception/RAII incompatibility with Postgres's setjmp/longjmp error handling, strict use of Postgres memory contexts, removal of vendored dependencies (absl, cityhash), and dramatically faster compile times and smaller binaries (400 KB vs 1.8 MB on macOS, 1.4 MB vs 4.9 MB on Linux). The release also fixes a bug where UInt16 values were incorrectly converted to int16 instead of int32. No reload, restart, or ALTER EXTENSION UPDATE is required.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://postgr.es/p/9l8>

## Similar posts on daily.dev

- [pg\_clickhouse is the fastest Postgres extension on ClickBench](https://daily.dev/posts/pg-clickhouse-is-the-fastest-postgres-extension-on-clickbench-kslwk5lud) · ClickHouse · 4 upvotes · 0 comments
- [What's New in pg\_clickhouse v0.3.2: Postgres 19, TLS, Regex, and Memory](https://daily.dev/posts/what-s-new-in-pg-clickhouse-v0-3-2-postgres-19-tls-regex-and-memory-bsqvivpr0) · ClickHouse · 18 upvotes · 1 comments
- [Introducing pg\_clickhouse: A Postgres extension for querying ClickHouse](https://daily.dev/posts/introducing-pg-clickhouse-a-postgres-extension-for-querying-clickhouse-s9p7k0xdv) · ClickHouse · 35 upvotes · 4 comments

---

Tags: [#c](https://daily.dev/tags/c), [#postgresql](https://daily.dev/tags/postgresql), [#clickhouse](https://daily.dev/tags/clickhouse)

[View this post on daily.dev](https://daily.dev/posts/pg-clickhouse-0-3-1-now-with-more-c-h3naoiqtg)