1. X
  2. ClickHouse
Log inSign up
ClickHouse
4,756 posts
user avatar
ClickHouse
@ClickHouseDB
ClickHouse is the fastest open-source OLAP database ⚡ Download: clickhouse.com GitHub: clickhou.se/GitHub Slack: clickhouse.com/slack
Bay Area / Amsterdam
clickhouse.com
Joined January 2017
62
Following
18.4K
Followers
AffiliatesAffiliatesRepliesRepliesMediaMedia

New to X?

Sign up now to get your own personalized timeline!

Create account

By signing up, you agree to the Terms of Service and Privacy Policy, including Cookie Use.

Terms·Privacy·Cookies·Accessibility·Ads Info·© 2026 X Corp.
Don't miss what's happening
People on X are the first to know.
Log inSign up
  • user avatar
    ClickHouse
    @ClickHouseDB
    6h
    . @picnic promises groceries in a 20-minute window, which only works if the whole operation is visible in real time. clickhou.se/4fdjA7G So they run a Real-Time Insights platform on ClickHouse across 20+ fulfillment centers and 5,000+ trucks, feeding thousands of Grafana
    How Picnic uses ClickHouse for real-time analytics across 20+ fulfillment centers and 1 million unique stores
    How Picnic uses ClickHouse for real-time analytics across 20+ fulfillment centers and 1 million...
    From clickhouse.com
    1.5K01.5K
  • user avatar
    ClickHouse
    @ClickHouseDB
    Jul 17
    Ask ClickHouse for "the best footballer ever" and it returns Lionel Messi. ⚽ Semantic search where ClickHouse calls the embedding model for you: aiEmbed turns text into a vector on insert. Demoed with Ollama and OpenAI, and any OpenAI-compatible provider works.
    Vector embeddings in ClickHouse with Ollama and OpenAI | ClickHouse
    From clickhouse.com
    1.4K01.4K
  • user avatar
    ClickHouse
    @ClickHouseDB
    Jul 17
    Full-text search on object storage needs a different index design than on local disk. 94.5% of tokens appear in ≤6 rows - that's the insight that made it work. We wrote it up in March.
    Building high-performance full-text search for object storage
    Building high-performance full-text search for object storage | ClickHouse
    From clickhouse.com
    1.4K01.4K
  • user avatar
    ClickHouse
    @ClickHouseDB
    Jul 17
    Bangkok 🇹🇭 we're coming to One Bangkok Tower next Thursday! Bangkok OSS & Data Evening: Queries, Code & Community, hosted with LINE MAN Wongnai 🔹 ClickHouse in the AI era, with a live AI support agent demo (ARISE by Infinitas) 🔹 Scalable, secure data pipelines around
    1.1K01.1K
  • ClickHouse reposted
    user avatar
    Sai Srirampur
    @saisrirampur
    Jul 16
    .Love testimonials like this! Brings a ton of validation to the hard work team has been putting to build the world's fastest and most reliable Postgres service. Thank you @asaiUwU for the kind words and all the feedback during the migration. 🙏 @ClickHouseDB
    user avatar
    ClickHouse
    @ClickHouseDB
    Jul 16
    We caught up with @roanakb and @asaiUwU from @TrainyAI, a @ycombinator company, to learn how switching from Amazon RDS to @ClickHouseDB Managed Postgres helped them make their OSS experiment tracker, Pluto, faster and cheaper to run, while bringing it under one unified roof 👇
    6.5K06.5K
  • user avatar
    ClickHouse
    @ClickHouseDB
    Jul 16
    Is ClickHouse winning the observability wars? Charity Majors makes the case in our July newsletter, alongside hypothetical skip indexes in 26.6, a CostBench showdown with Snowflake, and our first virtual hackathon. 🔗
    July 2026 newsletter
    July 2026 newsletter | ClickHouse
    From clickhouse.com
    8410841
  • user avatar
    ClickHouse
    @ClickHouseDB
    Jul 16
    We caught up with @roanakb and @asaiUwU from @TrainyAI, a @ycombinator company, to learn how switching from Amazon RDS to @ClickHouseDB Managed Postgres helped them make their OSS experiment tracker, Pluto, faster and cheaper to run, while bringing it under one unified roof 👇
    Why Trainy migrated from Amazon RDS Postgres to ClickHouse Managed Postgres
    Why Trainy migrated from Amazon RDS Postgres to ClickHouse Managed Postgres | ClickHouse
    From clickhouse.com
    5.1K05.1K
  • user avatar
    ClickHouse
    @ClickHouseDB
    Jul 16
    This Saturday in Delhi NCR 🇮🇳 ClickHouse in the Wild: Architecture Stories from Production 🔹 Zykrr on migrating 150M+ rows from PostgreSQL to ClickHouse with zero downtime 🔹 T9L on sub-second IoT logging for a distributed solar energy grid 🔹 ClickHouse on performance
    9780978
  • user avatar
    ClickHouse
    @ClickHouseDB
    Jul 16
    Whether you're evaluating ClickHouse, building a proof of concept, or already running workloads, join ClickHouse expert Johnny Mirza to ask your questions on architecture, performance, migrations, best practices, or your own use case—and get expert guidance to help you move
    ClickHouse Open Office & Live AMA
    ClickHouse Open Office & Live AMA | ClickHouse
    From clickhouse.com
    8140814
  • user avatar
    ClickHouse
    @ClickHouseDB
    Jul 15
    16.2 billion rows of Binance tick data. 76 GiB on disk. $1.88/month. Queryable with standard SQL. New post walks through VWAP, OHLC candles, and ASOF JOINs, plus a flash crash analysis showing slippage spike to 260× normal in one second.
    Replacing the HDB: ClickHouse for historical ticker data
    Replacing the HDB: ClickHouse for historical ticker data | ClickHouse
    From clickhouse.com
    1.1K01.1K
  • user avatar
    ClickHouse
    @ClickHouseDB
    Jul 15
    🚀 ClickHouse v26.7 Community Call: July 23, 8 AM PDT / 5 PM CEST clickhou.se/4w4hVZ5 Live with Alexey Milovidov: new features, live demos, roadmap sneak peeks, and open Q&A. Users, contributors, and the ClickHouse-curious all welcome 👇
    v26.7 Community Call
    v26.7 Community Call | ClickHouse
    From clickhouse.com
    9350935
  • user avatar
    ClickHouse
    @ClickHouseDB
    Jul 15
    clickhouse/rowbinary is a Node.js reader and writer for ClickHouse's RowBinary format that doubles as an Agent Skill. Instead of calling the library as a black box, a coding agent can read it as a reference implementation and forks it into a parser specialized for your exact
    @clickhouse/rowbinary: when your library is also a parser compiler
    @clickhouse/rowbinary: when your library is also a parser compiler | ClickHouse
    From clickhouse.com
    1.3K01.3K
  • user avatar
    ClickHouse
    @ClickHouseDB
    Jul 14
    . @bulletxyz and @Tristan0x are building DeFi's fastest trading exchange… but their old Databricks/Spark-based analytics stack told a different story. clickhou.se/3RA13dO See how switching to @ClickHouseDB cut query latency 10,000x, improved data freshness from 1-2 hours
    How Bullet uses ClickHouse Cloud to give DeFi's fastest exchange real-time analytics
    How Bullet uses ClickHouse Cloud to give DeFi's fastest exchange real-time analytics | ClickHouse
    From clickhouse.com
    8.1K08.1K
  • user avatar
    ClickHouse
    @ClickHouseDB
    Jul 14
    Postgres page tables scale with connections: on a 32GB shared_buffers, we measured 6.12GB of kernel page tables at 200 connections with 4KB pages, and 111MB with 2MB huge pages, plus 12% more TPS. 🐘 How ClickHouse Managed Postgres configures huge pages, measured on real
    How we configure huge pages in ClickHouse Managed Postgres
    How we configure huge pages in ClickHouse Managed Postgres | ClickHouse
    From clickhouse.com
    2.5K02.5K