--- title: Best ClickHouse posts — January 2026 | daily.dev description: The most upvoted ClickHouse posts from January 2026, curated by the daily.dev community. canonical: https://daily.dev/sources/clickhouse/best-of/2026/01 twitter:card: summary_large_image twitter:site: @dailydotdev og:url: https://daily.dev/sources/clickhouse/best-of/2026/01 og:type: website og:site_name: daily.dev og:title: Best ClickHouse posts — January 2026 | daily.dev og:description: The most upvoted ClickHouse posts from January 2026, curated by the daily.dev community. og:image: https://media.daily.dev/image/upload/s--VAY5ToZt--/f_auto/v1724209435/public/daily.dev%20-%20open%20graph --- # Best of ClickHouse — January 2026 1. 1 [](https://daily.dev/posts/fast-scalable-enterprise-grade-postgres-natively-integrated-with-clickhouse-whtgalabx "Fast, scalable, enterprise-grade Postgres natively integrated with ClickHouse") Article ClickHouse · 33w Fast, scalable, enterprise-grade Postgres natively integrated with ClickHouse ClickHouse announces a managed Postgres service backed by NVMe storage, delivering up to 10X faster performance for disk-bound workloads. The service integrates natively with ClickHouse through CDC capabilities and the pg\_clickhouse extension, enabling a unified data stack that combines transactional (Postgres) and analytical (ClickHouse) workloads. Built in partnership with Ubicloud, it offers enterprise-grade features including high availability, automatic backups, and point-in-time recovery, with all integration components being open source. 56 1 2. 2 [](https://daily.dev/posts/christmas-gifts-from-the-clickhouse-engineering-team-bbohktf7x "Christmas gifts from the ClickHouse engineering team") Article ClickHouse · 33w Christmas gifts from the ClickHouse engineering team ClickHouse 25.12 introduces several performance optimizations and UX improvements. Numeric hints now display for all rows in multi-value results when space permits. The distinctJSONPaths function is 50x faster by using metadata instead of scanning JSON columns. DISTINCT queries on LowCardinality columns now operate on dictionary IDs rather than full values, improving performance up to 6x. SEMI JOIN queries benefit from filter pushdown optimization, reducing data scanned by 30% and improving query speed by similar margins. 23 3. 3 [](https://daily.dev/posts/your-ai-sre-needs-better-observability-not-bigger-models--ezacq61op "Your AI SRE needs better observability, not bigger models.") Article ClickHouse · 36w Your AI SRE needs better observability, not bigger models. AI SRE tools fail not because of weak models, but because they lack proper observability foundations. Legacy systems with short retention windows, dropped high-cardinality data, and slow queries prevent AI from performing effective root cause analysis. ClickHouse's columnar architecture enables long-retention, high-cardinality observability at scale with sub-second query speeds, making it ideal for AI SRE copilots. The article presents a reference architecture combining ClickHouse with context layers (deployments, topology, incident history) and LLMs via SQL to create an investigative copilot that correlates data and surfaces insights while keeping humans in control of remediation decisions. 21 [See all ClickHouse archives](/sources/clickhouse/best-of) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@graph":[{"@type":"CollectionPage","@id":"https://daily.dev/sources/clickhouse/best-of/2026/01#page","url":"https://daily.dev/sources/clickhouse/best-of/2026/01","name":"Best ClickHouse Posts — January 2026","description":"The most upvoted ClickHouse posts from January 2026, curated by the daily.dev community.","isPartOf":{"@type":"WebSite","url":"https://daily.dev"}},{"@type":"ItemList","@id":"https://daily.dev/sources/clickhouse/best-of/2026/01#items","numberOfItems":3,"itemListElement":[{"@type":"ListItem","position":1,"url":"https://daily.dev/posts/fast-scalable-enterprise-grade-postgres-natively-integrated-with-clickhouse-whtgalabx","name":"Fast, scalable, enterprise-grade Postgres natively integrated with ClickHouse"},{"@type":"ListItem","position":2,"url":"https://daily.dev/posts/christmas-gifts-from-the-clickhouse-engineering-team-bbohktf7x","name":"Christmas gifts from the ClickHouse engineering team"},{"@type":"ListItem","position":3,"url":"https://daily.dev/posts/your-ai-sre-needs-better-observability-not-bigger-models--ezacq61op","name":"Your AI SRE needs better observability, not bigger models."}]},{"@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Sources","item":"https://daily.dev/sources"},{"@type":"ListItem","position":3,"name":"ClickHouse","item":"https://daily.dev/sources/clickhouse"},{"@type":"ListItem","position":4,"name":"Best of","item":"https://daily.dev/sources/clickhouse/best-of"},{"@type":"ListItem","position":5,"name":"January 2026"}]}]} ```