wrkm.app
Search
Databases

David Wheeler: pg_clickhouse 0.11.1: Now with pgvector, UPDATE, DELETE pushdown

Don't let the minor version increment fool you: pg_clickhouse v0.11.1, released last week, delivers a slew of improvements and bug fixes, including UPDATE, DELETE, TRUNCATE, and pgvector search pushdown.pgvector type mappingLet's start with the latter: pgvector type mapping. Given this ClickHouse table:CALL clickhouse_perform('ch_server', $$ CREATE TABLE items ( id Int32, category String, v Array(Float32) ) ENGINE = MergeTree ORDER BY (id); $$);

Editor
Nov 19, 2026 · 1 min read
David Wheeler: pg_clickhouse 0.11.1: Now with pgvector, UPDATE, DELETE pushdown

Don't let the minor version increment fool you: pg_clickhouse v0.11.1, released last week, delivers a slew of improvements and bug fixes, including UPDATE, DELETE, TRUNCATE, and pgvector search pushdown.pgvector type mappingLet's start with the latter: pgvector type mapping. Given this ClickHouse table:CALL clickhouse_perform('ch_server', $$ CREATE TABLE items ( id Int32, category String, v Array(Float32) ) ENGINE = MergeTree ORDER BY (id); $$);

Kaynak: Planet PostgreSQL

#PostgreSQL
Share

From other categories