# clickhouse

Open-source column-oriented database management system for real-time analytical queries.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## How Infinitas Learning uses ClickHouse Managed Postgres to process billions of events for 1.6M unique learners

DevFeed: [How Infinitas Learning uses ClickHouse Managed Postgres to process billions of events for 1.6M unique learners](<https://devfeed.tech/articles/how-infinitas-learning-uses-clickhouse-managed-postgres-to-process-billions-of-events-for-1-6m-unique-learners-136653.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/infinitas-learning-clickhouse-managed-postgres>)

Author: ClickHouse

Published: 2026-11-16T10:54:45Z

Content type: news

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [streaming data analytics](<https://devfeed.tech/topics/streaming-data-analytics.md>), [Apache Kafka](<https://devfeed.tech/topics/apache-kafka.md>), [self-hosted databases vs managed services](<https://devfeed.tech/topics/self-hosted-databases-vs-managed-services.md>)

Tags: [1-6](<https://devfeed.tech/tags/1-6.md>), [about](<https://devfeed.tech/tags/about.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [cache](<https://devfeed.tech/tags/cache.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [distributed](<https://devfeed.tech/tags/distributed.md>), [distributed-cache](<https://devfeed.tech/tags/distributed-cache.md>), [events](<https://devfeed.tech/tags/events.md>), [latency](<https://devfeed.tech/tags/latency.md>), [learning](<https://devfeed.tech/tags/learning.md>), [managed](<https://devfeed.tech/tags/managed.md>), [p99](<https://devfeed.tech/tags/p99.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [process](<https://devfeed.tech/tags/process.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [time](<https://devfeed.tech/tags/time.md>), [transactions](<https://devfeed.tech/tags/transactions.md>), [unique](<https://devfeed.tech/tags/unique.md>), [uses](<https://devfeed.tech/tags/uses.md>)

### AI overview

Infinitas Learning separates learner-result transactions from customer-facing analytics: Postgres processes assignment events and updates learner progress, while ClickHouse Cloud serves teacher dashboards. After Neon, the team moved 750 GB to ClickHouse Managed Postgres in 16 hours and completed a no-downtime cutover in 20 minutes; reported P50 transaction latency fell from milliseconds to double-digit microseconds. For analytics, ClickHouse compressed a nearly 2-billion-row table from 300 GB to 27 GB, but cache misses caused P99 spikes up to 13 seconds against a 500 ms target. Self-hosting brought P99 to 300 ms but left the team responsible for operations and running a single replica. With ClickHouse support optimizing data and settings, then enabling distributed cache in Cloud, load-test P99 reached 410 ms. The team plans to connect Postgres and ClickHouse through pg_clickhouse, but that integration is described as a future vision.

### Source excerpt

Infinitas Learning runs transactions for 1.6 million learners on ClickHouse Managed Postgres and serves real-time analytics to teachers from ClickHouse Cloud, where distributed cache cut P99 latency from about 13 seconds to 410 milliseconds.

## JSONBench is back, and ClickHouse still leads

DevFeed: [JSONBench is back, and ClickHouse still leads](<https://devfeed.tech/articles/jsonbench-is-back-and-clickhouse-still-leads-136654.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/jsonbench-is-back-clickhouse-still-leads>)

Author: Tom Schreiber; Mark Needham

Published: 2026-11-16T00:30:00Z

Content type: news

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [JSON](<https://devfeed.tech/topics/json.md>), [DuckDB](<https://devfeed.tech/topics/duckdb.md>), [reproducibility](<https://devfeed.tech/topics/reproducibility.md>), [elasticsearch](<https://devfeed.tech/topics/elasticsearch.md>), [Compression](<https://devfeed.tech/topics/compression.md>)

Tags: [benchmark](<https://devfeed.tech/tags/benchmark.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [database](<https://devfeed.tech/tags/database.md>), [engines](<https://devfeed.tech/tags/engines.md>), [json](<https://devfeed.tech/tags/json.md>)

### AI overview

In the described billion-document Bluesky event aggregation, ClickHouse returned results in 661 ms on a cold run, while MongoDB took 32 minutes 26 seconds on the same machine type and published configurations. The article attributes ClickHouse's JSON analytics performance to columnar storage, compression, and parallel processing that reads the fields a query needs. JSONBench has expanded from five to 27 database engines; ClickHouse also leads the broader comparison, which reports combined scores rather than query-time multipliers and penalizes unsuccessful queries and incomplete loads. The benchmark is open source, with public data, queries, configurations, and results, so others can reproduce measurements or contribute systems and improvements. The article also cites ClickHouse JSON changes including faster reads, lower memory use, indexes, Parquet support, and type hints without rewriting historical data.

### Source excerpt

JSONBench now compares 27 database engines. ClickHouse still leads on a billion JSON documents. Explore the results and run the benchmark yourself.

## The largest expansion of ClickHouse yet

DevFeed: [The largest expansion of ClickHouse yet](<https://devfeed.tech/articles/the-largest-expansion-of-clickhouse-yet-124825.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/announcing-clickhouse-platform-largest-expansion>)

Author: ClickHouse

Published: 2026-11-09T00:45:00Z

Content type: release

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [observability](<https://devfeed.tech/topics/observability.md>), [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [LLM observability](<https://devfeed.tech/topics/llm-observability.md>), [OpenTelemetry](<https://devfeed.tech/topics/opentelemetry.md>), [Threat monitoring](<https://devfeed.tech/topics/threat-monitoring.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [ai-gateway](<https://devfeed.tech/tags/ai-gateway.md>), [beta](<https://devfeed.tech/tags/beta.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [gateway](<https://devfeed.tech/tags/gateway.md>), [langfuse](<https://devfeed.tech/tags/langfuse.md>), [launches](<https://devfeed.tech/tags/launches.md>), [managed](<https://devfeed.tech/tags/managed.md>), [observability](<https://devfeed.tech/tags/observability.md>), [open](<https://devfeed.tech/tags/open.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [open-source-ai](<https://devfeed.tech/tags/open-source-ai.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [preview](<https://devfeed.tech/tags/preview.md>), [private](<https://devfeed.tech/tags/private.md>), [public](<https://devfeed.tech/tags/public.md>), [public-beta](<https://devfeed.tech/tags/public-beta.md>), [security](<https://devfeed.tech/tags/security.md>)

### AI overview

ClickHouse is expanding its cloud platform across transactions, observability, security, and AI engineering. Managed Postgres is generally available: NVMe-backed PostgreSQL includes high availability, automated backups, sub-second change data capture into ClickHouse, and the pg_clickhouse extension for querying ClickHouse through PostgreSQL. Xata's acquisition is intended to accelerate instant branching, cloning, and scale-to-zero environments. ClickHouse Observability is in public beta for OpenTelemetry logs, metrics, traces, and session data, with full-fidelity, high-cardinality retention and investigation at scale. ClickHouse Security is in private preview; its SIEM connects over 100 cloud, identity, and SaaS sources, provides built-in log pipelines and detections, and uses AI agents for alert triage and investigation. Langfuse's open-source AI Gateway is in public beta and routes model requests to trace usage and costs without application code changes; it is available self-hosted or on Langfuse Cloud.

### Source excerpt

ClickHouse Managed Postgres is generally available, ClickHouse Observability enters public beta, ClickHouse Security launches in private preview, Langfuse introduces an open-source AI Gateway, and ClickHouse acquires Xata.

## NetSuite to ClickHouse: SuiteAnalytics Connect, Sync Methods & Ledger Modeling Guide

DevFeed: [NetSuite to ClickHouse: SuiteAnalytics Connect, Sync Methods & Ledger Modeling Guide](<https://devfeed.tech/articles/netsuite-to-clickhouse-suiteanalytics-connect-sync-methods-ledger-modeling-guide-121704.md>)

Original publisher: [Read original article](<https://estuary.dev/blog/netsuite-to-clickhouse>)

Author: Seán Whelan

Published: 2026-11-06T12:26:35Z

Content type: article

Language: en

Sources: [Estuary](<https://devfeed.tech/sources/estuary.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [elt](<https://devfeed.tech/topics/elt.md>), [build vs buy database solutions](<https://devfeed.tech/topics/build-vs-buy-database-solutions.md>)

Tags: [2](<https://devfeed.tech/tags/2.md>), [2026](<https://devfeed.tech/tags/2026.md>), [3](<https://devfeed.tech/tags/3.md>), [64-bit](<https://devfeed.tech/tags/64-bit.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [compare](<https://devfeed.tech/tags/compare.md>), [connect](<https://devfeed.tech/tags/connect.md>), [custom](<https://devfeed.tech/tags/custom.md>), [custom-fields](<https://devfeed.tech/tags/custom-fields.md>), [data](<https://devfeed.tech/tags/data.md>), [elt](<https://devfeed.tech/tags/elt.md>), [fields](<https://devfeed.tech/tags/fields.md>), [guide](<https://devfeed.tech/tags/guide.md>), [ledger](<https://devfeed.tech/tags/ledger.md>), [limits](<https://devfeed.tech/tags/limits.md>), [netsuite](<https://devfeed.tech/tags/netsuite.md>), [script](<https://devfeed.tech/tags/script.md>), [sync](<https://devfeed.tech/tags/sync.md>), [tool](<https://devfeed.tech/tags/tool.md>), [with](<https://devfeed.tech/tags/with.md>)

### AI overview

NetSuite-to-ClickHouse replication can use SuiteAnalytics Connect, REST/SuiteQL, exports, or an ELT platform; Connect is a paid, read-only add-on and is the route detailed here. Syncs backfill tables, then poll last-modified fields, re-read tables without usable cursors, and consult NetSuite's DeletedRecord log. Since deleted transaction lines are not logged, they require periodic re-reads and cleanup. In ClickHouse, use ReplacingMergeTree keyed by NetSuite IDs (transaction lines need `(transaction, id)`) and query with `FINAL` to resolve versions. For financial accuracy, model accounting lines by subsidiary and accounting book, and preserve amounts as Decimal; Estuary's Connect driver reads numeric values as Float64, so its guide recommends `castToString` followed by `toDecimal64` for exact sums. Estuary provides incremental capture and ClickHouse materialization, but has specific limits: accounting lines are refreshed through changed transactions, custom fields must be selected, and its SuiteQL connector without Connect is full-refresh only. The excerpt also outlines token-auth setup, role permissions, backfill, polling, and trial-balance validation.

### Source excerpt

Move NetSuite data to ClickHouse with SuiteAnalytics Connect, an ELT tool or a script. Compare 5 methods and plan for deletes, custom fields and limits.

## ClickHouse release 26.10

DevFeed: [ClickHouse release 26.10](<https://devfeed.tech/articles/clickhouse-release-26-10-121768.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/clickhouse-release-26-10>)

Author: ClickHouse

Published: 2026-11-06T11:45:40Z

Content type: release

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Release notes](<https://devfeed.tech/topics/release-notes.md>), [Cache](<https://devfeed.tech/topics/cache.md>), [Functional programming](<https://devfeed.tech/topics/functional-programming.md>)

Tags: [cache](<https://devfeed.tech/tags/cache.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [composition](<https://devfeed.tech/tags/composition.md>), [experimental](<https://devfeed.tech/tags/experimental.md>), [faster](<https://devfeed.tech/tags/faster.md>), [flexible](<https://devfeed.tech/tags/flexible.md>), [freeform](<https://devfeed.tech/tags/freeform.md>), [function](<https://devfeed.tech/tags/function.md>), [more](<https://devfeed.tech/tags/more.md>), [release](<https://devfeed.tech/tags/release.md>)

### AI overview

ClickHouse 26.10 adds SQL composition with `|`, quota limits on inserted rows, and new array and map functions. Integer division can optionally truncate toward zero through `sql_compatible_division_for_integers`; that setting is off by default, errors on division by zero, and does not change stored views. Large `IN` subquery sets can spill to disk, enabling the example query to run under a 512 MiB limit with a 128 MiB spill threshold and 203 MiB peak use. Benchmarks report faster grouping by multiple `LowCardinality` columns and about 94% fewer rows read for Top-K grouped queries with dynamic filtering. The experimental columns cache reuses decoded column data (the example's repeated query falls from 32-34 ms to 12 ms); it currently supports wide MergeTree parts. Experimental `LATERAL JOIN` requires enabling a setting. Arbitrary `JOIN` conditions support patterns such as `LIKE`, but may use a block nested loop as slow as a cross join. The release also adds Freeform text input, SQLite input/output formats, and string filtering during scans; the example reports similar time but peak memory falling about 98%.

### Source excerpt

ClickHouse 26.10 introduces function composition, more flexible joins, faster GROUP BY queries, disk spilling for IN subqueries, an experimental columns cache, and Freeform and SQLite formats.

## HubSpot to ClickHouse: Sync Methods, Setup & API Limits Guide

DevFeed: [HubSpot to ClickHouse: Sync Methods, Setup & API Limits Guide](<https://devfeed.tech/articles/hubspot-to-clickhouse-sync-methods-setup-api-limits-guide-118921.md>)

Original publisher: [Read original article](<https://estuary.dev/blog/hubspot-to-clickhouse>)

Author: Seán Whelan

Published: 2026-11-04T22:42:36Z

Content type: article

Language: en

Sources: [Estuary](<https://devfeed.tech/sources/estuary.md>)

Topics: [hubspot](<https://devfeed.tech/topics/hubspot.md>), [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [elt](<https://devfeed.tech/topics/elt.md>), [API](<https://devfeed.tech/topics/api.md>), [REST API](<https://devfeed.tech/topics/rest-api.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>)

Tags: [api](<https://devfeed.tech/tags/api.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [compare](<https://devfeed.tech/tags/compare.md>), [dedupe](<https://devfeed.tech/tags/dedupe.md>), [elt](<https://devfeed.tech/tags/elt.md>), [guide](<https://devfeed.tech/tags/guide.md>), [hubspot](<https://devfeed.tech/tags/hubspot.md>), [limits](<https://devfeed.tech/tags/limits.md>), [managed](<https://devfeed.tech/tags/managed.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [setup](<https://devfeed.tech/tags/setup.md>), [sync](<https://devfeed.tech/tags/sync.md>)

### AI overview

HubSpot can feed ClickHouse through CSV for one-off analysis, custom API code, open-source ELT, or a managed connector. Ongoing syncs must account for HubSpot API quotas, delayed search indexing, and incremental searches that omit archived or deleted records; calculated properties also need separate refreshes. In ClickHouse, use ReplacingMergeTree keyed by record ID and query with FINAL to deduplicate versions. The text describes Estuary polling recent-change and delayed search endpoints, retrying 429s, and refreshing calculated properties daily, but its HubSpot connector does not remove archived or merged records; those require reconciliation. Its associations omit labels and type IDs. Setup also depends on read scopes, a suitable ClickHouse version and grants, network access, sync scheduling, and batch sizes that avoid excessive parts. Rebuild history depends on collection storage retention, and property typing can trade convenience for precision.

### Source excerpt

Sync HubSpot to ClickHouse with a managed tool, open-source ELT or the HubSpot API. Compare 4 methods, plan for rate limits and dedupe with FINAL.

## Why ClickHouse Cloud wins at real-time analytics

DevFeed: [Why ClickHouse Cloud wins at real-time analytics](<https://devfeed.tech/articles/why-clickhouse-cloud-wins-at-real-time-analytics-105722.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/why-clickhouse-cloud-wins-at-real-time-analytics>)

Author: Tom Schreiber; Lionel Palacin

Published: 2026-10-28T06:10:06Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [streaming data analytics](<https://devfeed.tech/topics/streaming-data-analytics.md>), [Cloud Architecture](<https://devfeed.tech/topics/cloud-architecture.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>), [Event-Streaming](<https://devfeed.tech/topics/event-streaming.md>), [BigQuery](<https://devfeed.tech/topics/bigquery.md>), [Amazon Redshift](<https://devfeed.tech/topics/amazon-redshift.md>), [real-time](<https://devfeed.tech/topics/real-time.md>), [CI/CD](<https://devfeed.tech/topics/cicd.md>)

Tags: [agent](<https://devfeed.tech/tags/agent.md>), [agents](<https://devfeed.tech/tags/agents.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [data](<https://devfeed.tech/tags/data.md>), [elastic](<https://devfeed.tech/tags/elastic.md>), [queries](<https://devfeed.tech/tags/queries.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [real-time-analytics](<https://devfeed.tech/tags/real-time-analytics.md>), [scaling](<https://devfeed.tech/tags/scaling.md>)

### AI overview

In CostBench's continuous-ingestion workload, ClickHouse Cloud scored 412x-1,996x better end-to-end performance per dollar than Snowflake, Databricks, BigQuery Capacity, and Redshift Serverless. The benchmark streamed 113.2 billion quotes while queries ran, measuring preparation cost, freshness, query cost, and runtime. ClickHouse's daily summaries stayed current with raw data because insert-time materialized views sort and aggregate incoming batches in memory; the other tested systems refreshed summaries asynchronously, with lag. Preparation cost was $28.69, versus about $79-$696 for the others. Parallel execution across nodes, cores, and SIMD lanes supports fast queries: at the benchmark endpoint, interactive aggregates averaged about 15 ms and raw-data drill-downs roughly one second on a separate 16-core read service. ClickHouse Cloud can size ingest and query services independently over shared storage. The results describe this workload and configuration; the article notes that scaling is not perfectly linear and that its separate core-scaling and distributed-query experiments used already-loaded data. The post also cites customer examples, including Appcues reducing event-to-"

### Source excerpt

Explore how ClickHouse Cloud turns fresh data into fast answers with efficient preparation, parallelized queries, and elastic scaling.

## How Shipsidekick replaced Neon with ClickHouse Managed Postgres for 10x faster queries and better reliability

DevFeed: [How Shipsidekick replaced Neon with ClickHouse Managed Postgres for 10x faster queries and better reliability](<https://devfeed.tech/articles/how-shipsidekick-replaced-neon-with-clickhouse-managed-postgres-for-10x-faster-queries-and-better-reliability-97463.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/shipsidekick-neon-to-clickhouse-managed-postgres>)

Author: ClickHouse

Published: 2026-10-23T10:11:36Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Cache](<https://devfeed.tech/topics/cache.md>), [Prisma](<https://devfeed.tech/topics/prisma.md>)

Tags: [2025](<https://devfeed.tech/tags/2025.md>), [2026](<https://devfeed.tech/tags/2026.md>), [about](<https://devfeed.tech/tags/about.md>), [account](<https://devfeed.tech/tags/account.md>), [acquisition](<https://devfeed.tech/tags/acquisition.md>), [advice](<https://devfeed.tech/tags/advice.md>), [agent](<https://devfeed.tech/tags/agent.md>), [agents](<https://devfeed.tech/tags/agents.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-agents](<https://devfeed.tech/tags/ai-agents.md>), [all](<https://devfeed.tech/tags/all.md>), [also](<https://devfeed.tech/tags/also.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cpu](<https://devfeed.tech/tags/cpu.md>), [faster](<https://devfeed.tech/tags/faster.md>), [managed](<https://devfeed.tech/tags/managed.md>), [neon](<https://devfeed.tech/tags/neon.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [queries](<https://devfeed.tech/tags/queries.md>), [with](<https://devfeed.tech/tags/with.md>)

### AI overview

Shipsidekick moved roughly 500 GB from Neon to ClickHouse Managed Postgres over a weekend; ClickPipes replicated it in four to five hours. The company reports CPU use falling from constant 100% to 5-10%, cache hit rate rising from 30-35% to 99%, and queries averaging about 10 times faster. Its tests took 1 minute 20 seconds for a month of shipment data on Neon versus about 6 seconds on ClickHouse; a two-month query that did not finish on Neon returned in 20 seconds. Bundled PgBouncer absorbed the app's spiky Vercel traffic without additional pool configuration. The account describes prior pool exhaustion, outages, saturated resources, and slow Neon support. Tradeoffs include accepting that a single standby could lose about a second of writes on failover, and that ClickHouse read replicas must match the primary's size and price. An AI agent's query drove primary CPU to 40-50%, so Shipsidekick added timeouts to the read-only role and later planned a dedicated replica.

### Source excerpt

Shipsidekick moved from Neon to ClickHouse Managed Postgres in a single weekend, cutting CPU usage from 100% to 5-10% and making queries about 10x faster.

## Front-end observability at scale: How OpenReplay captures billions of daily events in real time with ClickHouse

DevFeed: [Front-end observability at scale: How OpenReplay captures billions of daily events in real time with ClickHouse](<https://devfeed.tech/articles/front-end-observability-at-scale-how-openreplay-captures-billions-of-daily-events-in-real-time-with-clickhouse-93148.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/openreplay-front-end-observability-at-scale-clickhouse>)

Author: ClickHouse

Published: 2026-10-21T18:40:19Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [session replay](<https://devfeed.tech/topics/session-replay.md>), [Frontend observability](<https://devfeed.tech/topics/frontend-observability.md>), [streaming data analytics](<https://devfeed.tech/topics/streaming-data-analytics.md>)

Tags: [2](<https://devfeed.tech/tags/2.md>), [2019](<https://devfeed.tech/tags/2019.md>), [about](<https://devfeed.tech/tags/about.md>), [absolute](<https://devfeed.tech/tags/absolute.md>), [agent](<https://devfeed.tech/tags/agent.md>), [agents](<https://devfeed.tech/tags/agents.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [daily](<https://devfeed.tech/tags/daily.md>), [events](<https://devfeed.tech/tags/events.md>), [front-end](<https://devfeed.tech/tags/front-end.md>), [observability](<https://devfeed.tech/tags/observability.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [queries](<https://devfeed.tech/tags/queries.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [retention](<https://devfeed.tech/tags/retention.md>), [scale](<https://devfeed.tech/tags/scale.md>), [time](<https://devfeed.tech/tags/time.md>), [ttl](<https://devfeed.tech/tags/ttl.md>), [up](<https://devfeed.tech/tags/up.md>), [with](<https://devfeed.tech/tags/with.md>)

### AI overview

OpenReplay moved behavioral event analytics from Postgres to ClickHouse after indexed, partitioned, and sharded session searches still took about three seconds on average and sometimes up to ten; ClickHouse brought average response time to about one second and compressed roughly 1 TB of event tables to 1-2 GB. Retention now uses a ClickHouse TTL setting, replacing scripts, table locks, vacuuming, and weekend cleanup work. Events flow through materialized views, cutting some pipeline changes from two days to about half a day; Go code remains for parts of the pipeline and faster insertion once schemas stabilize. OpenReplay stores metadata in Postgres and recording files in object storage with lifecycle rules. Its self-hosted deployments use one ClickHouse instance and scale vertically, with reported customers reaching billions of events and up to 6 TB daily. The tradeoff is deliberate: a lean single-instance design for customer-controlled infrastructure, rather than sharding; the account says a SaaS-only deployment might use ClickHouse Cloud.

### Source excerpt

OpenReplay replaced Postgres with ClickHouse to ingest billions of events and up to 6 TB a day on a single, vertically scaled instance, with sub-second queries and retention handled by a single TTL setting.

## Running ClickHouse on NVIDIA Vera CPU: Is your favorite database up to the challenge?

DevFeed: [Running ClickHouse on NVIDIA Vera CPU: Is your favorite database up to the challenge?](<https://devfeed.tech/articles/running-clickhouse-on-nvidia-vera-cpu-is-your-favorite-database-up-to-the-challenge-92776.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/clickhouse-performance-on-nvidia-vera>)

Author: Robert Schulze

Published: 2026-10-21T13:13:15Z

Content type: news

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [NVIDIA Vera](<https://devfeed.tech/topics/nvidia-vera.md>), [database-optimization](<https://devfeed.tech/topics/database-optimization.md>), [database-scalability](<https://devfeed.tech/topics/database-scalability.md>), [Distributed Systems & Parallel Computing](<https://devfeed.tech/topics/distributed-systems-parallel-computing.md>), [High-Performance Computing](<https://devfeed.tech/topics/high-performance-computing.md>)

Tags: [agent](<https://devfeed.tech/tags/agent.md>), [agentic](<https://devfeed.tech/tags/agentic.md>), [agents](<https://devfeed.tech/tags/agents.md>), [aggregation](<https://devfeed.tech/tags/aggregation.md>), [ai](<https://devfeed.tech/tags/ai.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [benchmarks](<https://devfeed.tech/tags/benchmarks.md>), [challenge](<https://devfeed.tech/tags/challenge.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cpu](<https://devfeed.tech/tags/cpu.md>), [database](<https://devfeed.tech/tags/database.md>), [hardware](<https://devfeed.tech/tags/hardware.md>), [leaderboard](<https://devfeed.tech/tags/leaderboard.md>), [nvidia](<https://devfeed.tech/tags/nvidia.md>), [nvidia-vera](<https://devfeed.tech/tags/nvidia-vera.md>), [nvidia-vera-cpu](<https://devfeed.tech/tags/nvidia-vera-cpu.md>), [running](<https://devfeed.tech/tags/running.md>), [scaling](<https://devfeed.tech/tags/scaling.md>), [vera](<https://devfeed.tech/tags/vera.md>), [vera-cpu](<https://devfeed.tech/tags/vera-cpu.md>)

### AI overview

On a 176-core, two-socket NVIDIA Vera system, ClickHouse's standard binary scaled close to linearly in three in-memory microbenchmarks, with different limits by workload. A substring filter saturated near Vera's memory bandwidth (813-900 GB/s) at 64-256 threads; a more CPU-intensive regular-expression filter and a low-cardinality aggregation scaled almost linearly through physical cores, then gained less from SMT threads. A join between a 1 TB in-memory table and a 625,000-row sample also scaled nearly proportionally, using ClickHouse's parallel_hash algorithm and a runtime filter. The tests used synthetic data and Memory tables to avoid disk I/O, so the results do not directly establish performance for every workload. A separate single-thread integer filter took 0.42 seconds with compiler auto-vectorization and 1.48 seconds with it disabled; the text attributes the difference to SIMD.

### Source excerpt

NVIDIA Vera tops the ClickBench hardware leaderboard, and three micro-benchmarks for filters, aggregation and joins show ClickHouse scaling almost linearly across its 176 cores.

## How Ridgeline unified Iceberg and ClickHouse into one analytics layer for investment management

DevFeed: [How Ridgeline unified Iceberg and ClickHouse into one analytics layer for investment management](<https://devfeed.tech/articles/how-ridgeline-unified-iceberg-and-clickhouse-into-one-analytics-layer-for-investment-management-87284.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/ridgeline-iceberg-clickhouse-cloud>)

Author: ClickHouse

Published: 2026-10-14T17:36:29Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Apache Kafka](<https://devfeed.tech/topics/apache-kafka.md>), [table-partitioning](<https://devfeed.tech/topics/table-partitioning.md>), [Apache Spark](<https://devfeed.tech/topics/spark.md>), [Amazon Redshift](<https://devfeed.tech/topics/amazon-redshift.md>)

Tags: [architecture](<https://devfeed.tech/tags/architecture.md>), [aws](<https://devfeed.tech/tags/aws.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [cloud-native](<https://devfeed.tech/tags/cloud-native.md>), [cost](<https://devfeed.tech/tags/cost.md>), [data](<https://devfeed.tech/tags/data.md>), [deployments](<https://devfeed.tech/tags/deployments.md>), [iceberg](<https://devfeed.tech/tags/iceberg.md>), [it](<https://devfeed.tech/tags/it.md>), [performance](<https://devfeed.tech/tags/performance.md>), [querying](<https://devfeed.tech/tags/querying.md>)

### AI overview

Ridgeline moved its investment performance analytics from Postgres to ClickHouse Cloud, using Iceberg for older history and ClickHouse for recent data. The architecture handles larger customer workloads, cut reporting batches from hours to minutes, and helped the company more than double the customers live on its platform.

### Source excerpt

Ridgeline rebuilt its performance analytics on ClickHouse Cloud, querying decades of Iceberg history alongside recent data so it can serve investment managers 10x larger than before and more than double the customers live on its platform.

## ClickHouse Cloud and Redshift Serverless benchmarked for real-time analytics

DevFeed: [ClickHouse Cloud and Redshift Serverless benchmarked for real-time analytics](<https://devfeed.tech/articles/why-redshift-serverless-can-t-match-clickhouse-cloud-for-real-time-analytics-86660.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/clickhouse-vs-redshift-serverless-real-time-performance-per-dollar>)

Author: Tom Schreiber; Lionel Palacin

Published: 2026-10-14T09:07:30Z

Content type: comparison

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Amazon Redshift](<https://devfeed.tech/topics/amazon-redshift.md>), [Event-Streaming](<https://devfeed.tech/topics/event-streaming.md>), [streaming data analytics](<https://devfeed.tech/topics/streaming-data-analytics.md>), [Redpanda](<https://devfeed.tech/topics/redpanda-data-streaming.md>), [Serverless](<https://devfeed.tech/topics/serverless.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [benchmark](<https://devfeed.tech/tags/benchmark.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [real-time-analytics](<https://devfeed.tech/tags/real-time-analytics.md>), [redshift](<https://devfeed.tech/tags/redshift.md>)

### AI overview

CostBench compares ClickHouse Cloud and Redshift Serverless during continuous ingestion of stock-market quotes while analytical queries run. ClickHouse Cloud had lower modeled preparation and query costs and shorter accumulated query runtimes in the tested setup, producing a reported 1,996x performance-per-dollar result. The article describes differences in ingestion, pre-aggregation freshness, and query-serving paths, while noting that the score uses modeled costs and specific workload and capacity assumptions.

### Source excerpt

ClickHouse Cloud delivered 1,996x better performance per dollar than Redshift Serverless in CostBench. We trace the gap from fresh data arriving to fast answers coming back.

## A practical guide to real-time analytics in 2026

DevFeed: [A practical guide to real-time analytics in 2026](<https://devfeed.tech/articles/a-practical-guide-to-real-time-analytics-in-2026-86529.md>)

Original publisher: [Read original article](<https://www.databricks.com/blog/practical-guide-real-time-analytics-2026>)

Author: Jeremy Lewallen; Tad Rosenberg; Kaitlin Baumgardner

Published: 2026-10-13T19:17:26Z

Content type: article

Language: en

Sources: [Databricks](<https://devfeed.tech/sources/databricks.md>)

Topics: [real-time](<https://devfeed.tech/topics/real-time.md>), [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [data lake](<https://devfeed.tech/topics/data-lake.md>), [olap](<https://devfeed.tech/topics/olap.md>), [product analytics](<https://devfeed.tech/topics/product-analytics.md>)

Tags: [access-controls](<https://devfeed.tech/tags/access-controls.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [batch-processing](<https://devfeed.tech/tags/batch-processing.md>), [concurrency](<https://devfeed.tech/tags/concurrency.md>), [dashboards](<https://devfeed.tech/tags/dashboards.md>), [data](<https://devfeed.tech/tags/data.md>), [data-analytics](<https://devfeed.tech/tags/data-analytics.md>), [decision-making](<https://devfeed.tech/tags/decision-making.md>), [lakehouse](<https://devfeed.tech/tags/lakehouse.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [real-time-analytics](<https://devfeed.tech/tags/real-time-analytics.md>)

### AI overview

Real-time analytics helps teams query fresh data with low latency and high concurrency. This guide explains how to assess workloads across those dimensions, compares real-time and batch analytics, and describes the operational overhead of separate serving layers. It presents a lakehouse approach for running real-time and traditional analytics on shared data and governance, with Databricks Lakehouse//RT as an example.

### Source excerpt

Data has always been central to business decision-making, and most analytical workloads...

## Introducing JWT authentication in ClickHouse Cloud

DevFeed: [Introducing JWT authentication in ClickHouse Cloud](<https://devfeed.tech/articles/introducing-jwt-authentication-in-clickhouse-cloud-77071.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/introducing-jwt-authentication-in-clickhouse-cloud>)

Author: ClickHouse team

Published: 2026-10-08T13:55:14Z

Content type: release

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [JSON Web Tokens](<https://devfeed.tech/topics/jwt.md>), [Authentication](<https://devfeed.tech/topics/authentication.md>), [OpenID connect (OIDC)](<https://devfeed.tech/topics/oidc.md>), [Access Control](<https://devfeed.tech/topics/access-control.md>)

Tags: [authentication](<https://devfeed.tech/tags/authentication.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [identity-provider](<https://devfeed.tech/tags/identity-provider.md>), [jwt](<https://devfeed.tech/tags/jwt.md>)

### AI overview

ClickHouse Cloud introduces JWT authentication using short-lived tokens from OpenID Connect providers instead of database passwords. The article explains provider configuration, client connections, token refresh, and ephemeral users whose permissions follow token claims. It also describes how quotas and policies persist across token expiration. Custom provider configuration requires the Enterprise plan and service version 26.4 or later.

### Source excerpt

Connect to ClickHouse Cloud with short-lived tokens from your identity provider instead of database passwords.

## ClickHouse Cloud outperforms Databricks in a continuous-ingestion benchmark

DevFeed: [ClickHouse Cloud outperforms Databricks in a continuous-ingestion benchmark](<https://devfeed.tech/articles/why-databricks-can-t-match-clickhouse-cloud-for-real-time-analytics-65405.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/clickhouse-vs-databricks-real-time-performance-per-dollar>)

Author: Tom Schreiber; Lionel Palacin

Published: 2026-10-06T12:26:14Z

Content type: comparison

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [databricks](<https://devfeed.tech/topics/databricks.md>), [streaming data analytics](<https://devfeed.tech/topics/streaming-data-analytics.md>), [Rockset](<https://devfeed.tech/topics/rockset.md>)

Tags: [aggregation](<https://devfeed.tech/tags/aggregation.md>), [analyst](<https://devfeed.tech/tags/analyst.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [api](<https://devfeed.tech/tags/api.md>), [async](<https://devfeed.tech/tags/async.md>), [automatically](<https://devfeed.tech/tags/automatically.md>), [benchmark](<https://devfeed.tech/tags/benchmark.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [data](<https://devfeed.tech/tags/data.md>), [databricks](<https://devfeed.tech/tags/databricks.md>), [performance](<https://devfeed.tech/tags/performance.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [real-time-analytics](<https://devfeed.tech/tags/real-time-analytics.md>)

### AI overview

The CostBench comparison tested ClickHouse Cloud and Databricks Serverless SQL while streaming 113.2 billion stock-market quotes and running queries. In this workload, ClickHouse Cloud scored 752 times better on modeled end-to-end performance per dollar. The benchmark attributes the difference to lower preparation costs and query costs, faster query runtimes, and summaries kept current during inserts. The comparison excludes Databricks Lakehouse//RT, which was unavailable for testing, and the score is a modeled cost measure rather than a full provider invoice.

### Source excerpt

ClickHouse Cloud delivered 752x better performance per dollar than Databricks in CostBench. We trace the gap from fresh data arriving to fast answers coming back.

## ClickHouse now writes Apache Iceberg tables to Microsoft OneLake

DevFeed: [ClickHouse now writes Apache Iceberg tables to Microsoft OneLake](<https://devfeed.tech/articles/clickhouse-now-writes-apache-iceberg-tables-to-microsoft-onelake-61658.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/clickhouse-now-writes-to-microsoft-onelake>)

Author: Melvyn Peignon; Karolina Ruiz Rogelj

Published: 2026-09-29T13:03:07Z

Content type: release

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [Apache Iceberg](<https://devfeed.tech/topics/apache-iceberg.md>), [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Azure](<https://devfeed.tech/topics/azure.md>), [Microsoft](<https://devfeed.tech/topics/microsoft.md>)

Tags: [agent](<https://devfeed.tech/tags/agent.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [iceberg](<https://devfeed.tech/tags/iceberg.md>), [microsoft](<https://devfeed.tech/tags/microsoft.md>), [microsoft-fabric](<https://devfeed.tech/tags/microsoft-fabric.md>), [s3](<https://devfeed.tech/tags/s3.md>), [security](<https://devfeed.tech/tags/security.md>)

### AI overview

ClickHouse can now write Apache Iceberg tables directly to Microsoft OneLake, registering them in the OneLake catalog through Iceberg REST-based Table APIs and protecting them with OneLake Security. This enables compatible tools to discover and query the tables. The article describes AI workflows that publish analytical results to OneLake for organizational use.

### Source excerpt

ClickHouse today announced the ability to write directly to Microsoft OneLake, the unified data lake service within Microsoft Fabric.

## ClickHouse release 26.9

DevFeed: [ClickHouse release 26.9](<https://devfeed.tech/articles/clickhouse-release-26-9-59197.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/clickhouse-release-26-09>)

Author: ClickHouse

Published: 2026-09-23T00:00:00Z

Content type: release

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [DateTime](<https://devfeed.tech/topics/datetime.md>)

Tags: [arithmetic](<https://devfeed.tech/tags/arithmetic.md>), [bug-fixes](<https://devfeed.tech/tags/bug-fixes.md>), [count](<https://devfeed.tech/tags/count.md>), [faster](<https://devfeed.tech/tags/faster.md>), [incremental](<https://devfeed.tech/tags/incremental.md>), [min](<https://devfeed.tech/tags/min.md>), [optimizations](<https://devfeed.tech/tags/optimizations.md>), [queries](<https://devfeed.tech/tags/queries.md>), [range](<https://devfeed.tech/tags/range.md>), [release](<https://devfeed.tech/tags/release.md>), [time](<https://devfeed.tech/tags/time.md>), [timezone](<https://devfeed.tech/tags/timezone.md>)

### AI overview

ClickHouse 26.9 is a release containing new features, performance optimizations, and bug fixes. Highlights include conditional LIMIT boundaries, incremental refreshes for append-only materialized views, disk spilling for high-cardinality queries, time-limited tokens, expanded PromQL support, and faster min, max, and count queries.

### Source excerpt

ClickHouse 26.9 introduces conditional LIMIT boundaries, incremental refreshes for append-only materialized views, disk spilling for DISTINCT, time-limited tokens, and faster min/max/count queries.

## Fountain cut analytics latency and costs by rebuilding Cue's data plane on ClickHouse Cloud

DevFeed: [Fountain cut analytics latency and costs by rebuilding Cue's data plane on ClickHouse Cloud](<https://devfeed.tech/articles/how-fountain-rebuilt-its-data-plane-on-clickhouse-cloud-to-power-cue-the-frontline-superintelligence-58257.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/fountain-agentic-ai-for-high-volume-hiring>)

Author: ClickHouse

Published: 2026-09-22T14:52:36Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Latency](<https://devfeed.tech/topics/latency.md>), [AI Platform](<https://devfeed.tech/topics/ai-platform.md>), [Artificial Intelligence](<https://devfeed.tech/topics/ai.md>), [real-time](<https://devfeed.tech/topics/real-time.md>), [BigQuery](<https://devfeed.tech/topics/bigquery.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>), [Apache Iceberg](<https://devfeed.tech/topics/apache-iceberg.md>), [parquet](<https://devfeed.tech/topics/parquet.md>), [MongoDB](<https://devfeed.tech/topics/mongodb.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>)

Tags: [agentic-ai](<https://devfeed.tech/tags/agentic-ai.md>), [ai-platform](<https://devfeed.tech/tags/ai-platform.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [aws](<https://devfeed.tech/tags/aws.md>), [batch-processing](<https://devfeed.tech/tags/batch-processing.md>), [bigquery](<https://devfeed.tech/tags/bigquery.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [costs](<https://devfeed.tech/tags/costs.md>), [data-platform](<https://devfeed.tech/tags/data-platform.md>), [iceberg](<https://devfeed.tech/tags/iceberg.md>), [latency](<https://devfeed.tech/tags/latency.md>), [mongodb](<https://devfeed.tech/tags/mongodb.md>), [parquet](<https://devfeed.tech/tags/parquet.md>), [processing](<https://devfeed.tech/tags/processing.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [replication](<https://devfeed.tech/tags/replication.md>), [s3](<https://devfeed.tech/tags/s3.md>)

### AI overview

Fountain rebuilt the real-time data plane behind Cue, its agentic AI platform for frontline hiring, using ClickPipes and ClickHouse Cloud. The company reports reducing analytics latency from three hours to under two minutes, with most queries under one second, while lowering costs by about 66%.

### Source excerpt

Fountain cut analytics latency from three hours to under two minutes and costs by 66% by rebuilding Cue's data plane on ClickPipes and ClickHouse Cloud.

## ClickHouse appoints Mike Scarpelli, former Snowflake and ServiceNow CFO, to Board of Directors

DevFeed: [ClickHouse appoints Mike Scarpelli, former Snowflake and ServiceNow CFO, to Board of Directors](<https://devfeed.tech/articles/clickhouse-appoints-mike-scarpelli-former-snowflake-and-servicenow-cfo-to-board-of-directors-57843.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/clickhouse-appoints-mike-scarpelli-to-board-of-directors>)

Author: ClickHouse

Published: 2026-09-22T13:11:41Z

Content type: news

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [data](<https://devfeed.tech/topics/data.md>), [Finance](<https://devfeed.tech/topics/finance.md>)

Tags: [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [data](<https://devfeed.tech/tags/data.md>), [observability](<https://devfeed.tech/tags/observability.md>)

### AI overview

ClickHouse announced that Michael Scarpelli, former CFO of Snowflake and ServiceNow, has joined its board of directors as an independent director and Audit Committee chair. The announcement highlights ClickHouse's growth in revenue, customers, valuation, and employee count.

### Source excerpt

ClickHouse, a leader in real-time analytics, data warehousing, observability, and AI/ML, today announced the appointment of Michael Scarpelli to its Board of Directors

## Postgres on NVMe: performance and the convergence of transactions and analytics

DevFeed: [Postgres on NVMe: performance and the convergence of transactions and analytics](<https://devfeed.tech/articles/postgres-on-nvme-performance-and-the-convergence-of-transactions-and-analytics-57635.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/postgres-on-nvme>)

Author: Kaushik Iska

Published: 2026-09-21T15:47:52Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [Database](<https://devfeed.tech/topics/database.md>), [NVMe](<https://devfeed.tech/topics/nvme.md>), [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Latency](<https://devfeed.tech/topics/latency.md>), [Transactions](<https://devfeed.tech/topics/transactions.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [systems](<https://devfeed.tech/topics/systems.md>)

Tags: [cache](<https://devfeed.tech/tags/cache.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [latency](<https://devfeed.tech/tags/latency.md>), [nvme](<https://devfeed.tech/tags/nvme.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [replication](<https://devfeed.tech/tags/replication.md>), [ssd](<https://devfeed.tech/tags/ssd.md>), [storage](<https://devfeed.tech/tags/storage.md>), [transactions](<https://devfeed.tech/tags/transactions.md>)

### AI overview

This article explains how local NVMe storage can improve PostgreSQL transaction performance when working sets exceed memory, while noting that faster storage does not change PostgreSQL's row-store layout. It also explains why analytical workloads may still require ClickHouse as data volume, concurrency, and throughput increase.

### Source excerpt

See how local NVMe transforms Postgres transaction performance--and why ClickHouse remains essential for fast analytics as workloads scale.

## The official ClickHouse provider for Apache Airflow is now available

DevFeed: [The official ClickHouse provider for Apache Airflow is now available](<https://devfeed.tech/articles/the-official-clickhouse-provider-for-apache-airflow-is-now-available-42157.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/clickhouse-airflow-provider>)

Author: Aditya Chidurala; Bentsi Leviav; Alex Francoeur

Published: 2026-09-17T18:06:01Z

Content type: release

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [airflow](<https://devfeed.tech/topics/airflow.md>), [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Data pipelines](<https://devfeed.tech/topics/data-pipelines.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Python](<https://devfeed.tech/topics/python.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>)

Tags: [airflow](<https://devfeed.tech/tags/airflow.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [data-pipelines](<https://devfeed.tech/tags/data-pipelines.md>), [integration](<https://devfeed.tech/tags/integration.md>), [python](<https://devfeed.tech/tags/python.md>), [release](<https://devfeed.tech/tags/release.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

ClickHouse has released an officially maintained Apache Airflow provider for orchestrating ClickHouse data workflows. The provider uses ClickHouse Connect over HTTP(S), supports Airflow's common SQL operators, and includes a hook for bulk and client-specific operations.

### Source excerpt

The official ClickHouse provider for Apache Airflow simplifies data workflows with standard SQL operators, bulk inserts, and shared setup across self-managed Airflow and Astronomer.

## Postgres week in the Netherlands: PGDay Lowlands & Percona Live 2026

DevFeed: [Postgres week in the Netherlands: PGDay Lowlands & Percona Live 2026](<https://devfeed.tech/articles/postgres-week-in-the-netherlands-pgday-lowlands-percona-live-2026-42158.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/postgres-week-in-the-netherlands-pgday-lowlands-percona-live-2026>)

Author: Gülçin Yıldırım Jelínek

Published: 2026-09-17T14:02:33Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>), [Percona](<https://devfeed.tech/topics/percona.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [conference](<https://devfeed.tech/tags/conference.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [notes](<https://devfeed.tech/tags/notes.md>), [percona](<https://devfeed.tech/tags/percona.md>), [percona-live](<https://devfeed.tech/tags/percona-live.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>)

### AI overview

Notes from PGDay Lowlands and Percona Live 2026, including a lightning talk about using pg_clickhouse and pg_stat_ch to combine PostgreSQL with ClickHouse for analytics, plus a session on PostgreSQL 19 monitoring.

### Source excerpt

Notes from three days in the Netherlands, featuring a lightning talk on pg_clickhouse and pg_stat_ch at PGDay Lowlands and a session on PostgreSQL 19 monitoring at Percona Live Amsterdam.

## September 2026 newsletter

DevFeed: [September 2026 newsletter](<https://devfeed.tech/articles/september-2026-newsletter-41317.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/202609-newsletter>)

Author: Mark Needham

Published: 2026-09-17T13:42:49Z

Content type: news

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [releases](<https://devfeed.tech/topics/releases.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [Grafana Cloud Metrics](<https://devfeed.tech/topics/grafana-cloud-metrics.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [caching](<https://devfeed.tech/tags/caching.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [events](<https://devfeed.tech/tags/events.md>), [news](<https://devfeed.tech/tags/news.md>), [newsletter](<https://devfeed.tech/tags/newsletter.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [release](<https://devfeed.tech/tags/release.md>), [replication](<https://devfeed.tech/tags/replication.md>), [september-2026](<https://devfeed.tech/tags/september-2026.md>)

### AI overview

The September 2026 ClickHouse newsletter covers the 26.8 release, including custom HTTP handlers, pipelined SQL, dynamic query filtering, tokenizer support, and other features. It also summarizes replication-queue diagnostics, CostBench results, preview releases, community contributions, and upcoming events.

### Source excerpt

Welcome to the September 2026 ClickHouse newsletter, featuring ClickHouse 26.8, PromQL, On-Demand Compute, CostBench results, and the latest community news and events.

## ClickHouse is now available on the dbt platform

DevFeed: [ClickHouse is now available on the dbt platform](<https://devfeed.tech/articles/clickhouse-is-now-available-on-the-dbt-platform-31545.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/clickhouse-is-now-available-on-the-dbt-platform>)

Author: Aditya Chidurala; José Muñoz; Alex Francoeur

Published: 2026-09-16T19:38:40Z

Content type: release

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>), [Rust](<https://devfeed.tech/topics/rust.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>)

Tags: [adapter](<https://devfeed.tech/tags/adapter.md>), [announcements](<https://devfeed.tech/tags/announcements.md>), [beta](<https://devfeed.tech/tags/beta.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [dbt](<https://devfeed.tech/tags/dbt.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [platform](<https://devfeed.tech/tags/platform.md>), [release](<https://devfeed.tech/tags/release.md>), [rust](<https://devfeed.tech/tags/rust.md>)

### AI overview

ClickHouse announces a dbt v2 adapter powered by dbt's Rust engine, available in public beta. ClickHouse is also available as a natively supported data warehouse on dbt Platform in private beta, with support for open-source ClickHouse and ClickHouse Cloud.

### Source excerpt

The ClickHouse adapter for dbt v2 is in public beta, powered by dbt's Rust engine. ClickHouse also joins the dbt platform in private beta, supporting open-source ClickHouse and ClickHouse Cloud.

[Next page](<https://devfeed.tech/topics/clickhouse.md?cursor=WyIyMDI2LTA5LTE2VDE5OjM4OjQwKzAwOjAwIiwgImFiMDQ3N2ZjLTUzMzMtNDgzYy1hZTI3LTc5YTc5OTk0OTdhOCJd>)