# 10x speed, 10x savings: Constant Contact's journey from Pinot to ClickHouse

DevFeed: [10x speed, 10x savings: Constant Contact's journey from Pinot to ClickHouse](<https://devfeed.tech/articles/10x-speed-10x-savings-constant-contact-s-journey-from-pinot-to-clickhouse-5498.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/pinot-to-clickhouse-constant-contact>)

Author: ClickHouse

Published: 2025-11-04T07:39:45Z

Content type: article

Language: en

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

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [real-time](<https://devfeed.tech/topics/real-time.md>), [data](<https://devfeed.tech/topics/data.md>), [dashboards](<https://devfeed.tech/topics/dashboards.md>), [Databases](<https://devfeed.tech/topics/databases.md>)

Tags: [amazon](<https://devfeed.tech/tags/amazon.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [analytics-stack](<https://devfeed.tech/tags/analytics-stack.md>), [apache](<https://devfeed.tech/tags/apache.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [dashboards](<https://devfeed.tech/tags/dashboards.md>), [olap](<https://devfeed.tech/tags/olap.md>), [pinot](<https://devfeed.tech/tags/pinot.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [streaming](<https://devfeed.tech/tags/streaming.md>)

## AI overview

Constant Contact rebuilt its real-time analytics stack by migrating from Apache Pinot to ClickHouse. The article describes the scaling and maintenance problems caused by Pinot's handling of upserts and growing data volumes, and explains how ClickHouse fit the team's OLAP and reporting requirements.

## Source excerpt

Constant Contact rebuilt its real-time analytics stack with ClickHouse. In this blog post, they share their lessons doing so.