Content Deep Dive

pg_clickhouse 0.11.1: Now with pgvector, UPDATE, DELETE pushdown

Blog post from ClickHouse

Post Details
Company
Date Published
Author
-
Word Count
1,825
Company Posts That Month
28
Language
English
Hacker News Points
-
Post removed?
No
Summary

pg_clickhouse v0.11.1 adds substantial improvements, including mapping ClickHouse float arrays to PostgreSQL pgvector columns and pushing vector comparisons, distance calculations, and similarity-index detection to ClickHouse. It also supports pushing down UPDATE, DELETE, and TRUNCATE operations on MergeTree-family tables, with ClickHouse settings required for updates and a caution that unfiltered updates or deletes affect all rows. Other changes include pushdown for linear-regression aggregates on ClickHouse 26.9 and later, PostgreSQL-compatible NULL results for empty aggregates, JSONB subscript translation, improved timezone handling, and more precise support for unconstrained NUMERIC values. The release is available on ClickHouse Managed Postgres, and installations running v0.10 or earlier can upgrade with ALTER EXTENSION pg_clickhouse UPDATE.

Trends Found in this Post
Trend Post Mentions Total Month Mentions Posts Companies MoM
Vector Search 4 1,097 201 87 -45%
Use This Data

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.