shouldiuse.io

Comparison

ClickHouse vs Time-Series PostgreSQL at Petabyte Scale

ClickHouse and Time-Series PostgreSQL at Petabyte Scale both land on Depends.

ClickHouse versus Time-Series PostgreSQL at Petabyte Scale
CompareClickHouseTime-Series PostgreSQL at Petabyte Scale
VerdictDependsDepends
Best forReal-time analytics on billions of rowsIoT and metrics ingestion at scale
Who it's not forSmall apps needing a simple CRUD databaseSmall apps . plain Postgres handles modest metrics fine
PrivacyActive project with a public security changelog; several CVEs disclosed over the years, including RCE and SSRF issues.One known privilege-escalation CVE in TimescaleDB 2.8.0-2.9.2; no breaches found in sources reviewed.13
Support qualitySupport program exists but no quality evidenceNo support evidence in sources
Public sentimentUsers overwhelmingly praise speed, stability, and cost, while flagging operational complexity at extreme scale and thin GUI tooling.²G2 reviewers consistently praise ease of use, intuitive interface, and fast data processing.14
Biggest gotchaCloud pricing separates compute and storage; heavy ingest drives costs upEnterprise pricing is quote-only . costs stay opaque until you negotiate10

Pick ClickHouse when

  • Real-time analytics on billions of rows
  • Observability and log analytics at scale
  • User-facing embedded analytics
  • SQL-fluent data teams

When ClickHouse is not a fit

  • Small apps needing a simple CRUD database
  • Teams with no dedicated data or ops engineers
  • Transactional (OLTP) workloads
  • Anyone wanting spreadsheet-grade reporting

Pick Time-Series PostgreSQL at Petabyte Scale when

  • IoT and metrics ingestion at scale
  • Postgres shops needing time-series
  • Observability and monitoring backends
  • Teams wanting full SQL on time-series

When Time-Series PostgreSQL at Petabyte Scale is not a fit

  • Small apps . plain Postgres handles modest metrics fine
  • Teams with no SQL or Postgres experience
  • Workloads that aren't time-series shaped
  • Buyers needing published, predictable pricing

Sources

  1. ClickHouse Cloud Reviews & Ratings 2026gartner.com
    review
  2. Is Clickhouse a good choice? . r/dataengineeringreddit.com
    review
  3. ClickHouse at PB Scale: Drawbacks and Gotchasreddit.com
    review
  4. ClickHouse tops $250M ARR and 4000 customersclickhouse.com
    official
  5. ClickHouse lands $15B valuationbloomberg.com
    news
  6. 7 RCE and DoS vulnerabilities in ClickHousejfrog.com
    security
  7. CVE-2024-22412 . NIST NVDnvd.nist.gov
    security
  8. ClickHouse Pricingclickhouse.com
    official
  9. ClickHouse Reviews, Pricing & Featurescheckthat.ai
    review
  10. Tiger Data official sitetigerdata.com
    official
  11. TimescaleDB on GitHubgithub.com
    official
  12. Product security pagetimescale.com
    security
  13. Timescale CVEs . OpenCVEopencve.alliance.unm.edu
    security
  14. G2 reviews . Tiger Datag2.com
    review
  15. How TimescaleDB helped Cloudflare scale analyticsblog.cloudflare.com
    news
  16. Timescale raises $40M Series Bventurebeat.com
    news