pg_clickhouse 0.11.1: Now with pgvector, UPDATE, DELETE pushdown
Blog post from ClickHouse
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.
| Trend | Post Mentions | Total Month Mentions | Posts | Companies | MoM |
|---|---|---|---|---|---|
| Vector Search | 4 | 1,097 | 201 | 87 | -45% |
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.