Menu

#ClickHouse

35 posts

Feed·
20 of 35 posts
Seven local vector stores under one agent memory: in a 20,000-vector pilot only pgvector beat our brute-force numpy scan
📰
0Read More

Seven local vector stores under one agent memory: in a 20,000-vector pilot only pgvector beat our brute-force numpy scan

DEV Community: database·CryptoPunk Dz2·3 days ago
#gGaMr2pa
#devtodatabase#devto#dev#index#memory

I am Mycroft, Anton's synthetic AI cofounder. This report was put together with AI assistance from...

15s
Postgres to ClickHouse CDC Without Kafka: Attach a Polaris Catalog as a Database
🖼️
0Read More

Postgres to ClickHouse CDC Without Kafka: Attach a Polaris Catalog as a Database

DEV Community: postgres·Shubham Baldava·4 days ago
#Np8zWiQy
#devtopostgresql#devto#dev#catalog#olake

Replicate Postgres to ClickHouse with change data capture: an open source tool writes the WAL into Apache Polaris, and ClickHouse, DuckDB and Trino query it. Real run numbers.

15s
My First Contribution to ClickHouse: Two Weeks From "My Laptop Can't Build It" to 154 Green CI Checks
📰
0Read More

My First Contribution to ClickHouse: Two Weeks From "My Laptop Can't Build It" to 154 Green CI Checks

DEV Community: cpp·Zain Ulabidin·6 days ago
#kJodMxP3
#devtocpp#devto#dev#include#clickhouse

An honest walkthrough of contributing a crash fix to ClickHouse — the build wall, two false starts, a fuzzer-found logical error, and the three CI traps that taught me the most

15s
ClickHouse 26.10's string filter during scan cuts a selective LIKE query's memory 25-fold
📰
0Read More

ClickHouse 26.10's string filter during scan cuts a selective LIKE query's memory 25-fold

DEV Community: database·Alex Georgiev·6 days ago
#ds0bCH6V
#devtodatabase#devto#dev#setting#query

I benchmarked ClickHouse 26.10's new apply_string_filters_during_scan setting against 26.9: a selective LIKE query's peak memory dropped from 37.6MB to 1.5MB, but a plain WHERE equality got none of it until I rewrote it as PREWHERE.

15s
I've operated petabyte-scale ClickHouse® clusters for 5 years
🖼️
0Read More

I've operated petabyte-scale ClickHouse® clusters for 5 years

Hacker News·2 months ago
#4p5KxiBh

What I learned operating ClickHouse at scale: the wins, the failures, and the lessons that only come from production experience.

15s
What's new in pg_clickhouse v0.10.0: Subqueries, TPC-H Speedups, C Driver, and Aggregates | ClickHouse
🖼️
65Read More

What's new in pg_clickhouse v0.10.0: Subqueries, TPC-H Speedups, C Driver, and Aggregates | ClickHouse

Hacker News·3 months ago
#gDv3jUfX
#clickhouse#null#down#query#foreign

Discover what's new in pg_clickhouse v0.10.0: 16 of 22 TPC-H queries now push down in full, plus a rebuilt C driver and broader aggregate support.

15s
Why we rewrote WAL-G for Postgres backups in Rust: Meet WAL-RUS | ClickHouse
🖼️
132Read More

Why we rewrote WAL-G for Postgres backups in Rust: Meet WAL-RUS | ClickHouse

Hacker News·5 months ago
#Y25bRfqP
#clickhouse#memory#archival#postgres#making

How we built WAL-RUS, an open-source Rust-based Postgres backup tool that reduces virtual memory usage by over 70% compared to WAL-G while maintaining full compatibility.

15s
Ten years of ClickHouse in open source
🖼️
324Read More

Ten years of ClickHouse in open source

Hacker News·5 months ago
#GwZh3zfV
#clickhouse#first#code#open#photo

ClickHouse was released in open source on Jun 15 2016, ten years ago. Since then, it became the most popular open source analytical database with more than 2000 contributors.

15s
Three Ways to Set Up CDC from Postgres to ClickHouse
🖼️
0Read More

Three Ways to Set Up CDC from Postgres to ClickHouse

DEV Community: database·Hassan Munir·6 months ago
#e41wEuXQ
#dev#clickhouse#postgres#table#article

Postgres CDC into ClickHouse via Kafka + Debezium, MaterializedPostgreSQL, and ClickPipes — setup, schemas, monitoring SQL, and where each one breaks.

15s
Our billing pipeline was suddenly slow. The culprit was a hidden bottleneck in ClickHouse
🖼️
0Read More

Our billing pipeline was suddenly slow. The culprit was a hidden bottleneck in ClickHouse

The Cloudflare Blog ·James Morrison·6 months ago
#mGoGzwVY
#parts#query#clickhouse#namespace#article

When a partitioning change to our petabyte-scale ClickHouse cluster caused critical billing jobs to stall, standard metrics showed no obvious errors.…

15s
ClickHouse JOINs Aren't Slow Anymore (You're Reading 2020's Docs)
🖼️
0Read More

ClickHouse JOINs Aren't Slow Anymore (You're Reading 2020's Docs)

DEV Community·Aman Puri·6 months ago
#oLGkQF3l
#clickhouse#does#how#automatic#join

The 'avoid JOINs in ClickHouse' advice is four years and 50+ PRs out of date. Here's what actually shipped between 2022 and 2026.

15s