48.8 kRunning 8.5 TB of hot data in Postgres, with super low-latency on NVMe
ClickHouse Postgres has been an incredible fit for us as we migrated from Aurora and scaled our production workload. We're now running around 8.5 TB of hot data in Postgres (...)
The performance has been simply impressive, and the ClickHouse team has been a great partner.
Postgres managed by ClickHouse
Postgres rápido, escalable y enterprise-grade, integrado de forma nativa con ClickHouse.
Diseñado para aplicaciones en tiempo real e impulsadas por IA.
Un Unified Data Stack que combina Postgres para transacciones y ClickHouse para analítica, ¡sin complejidad adicional!
Con la confianza de
¿Por qué Postgres gestionado por ClickHouse?
Rendimiento NVMe
Postgres enterprise-grade sobre almacenamiento NVMe local. Latencia en microsegundos, IOPS prácticamente ilimitados y rendimiento consistente sin jitter de red.
Hasta 10× más rendimiento para cargas de trabajo intensivas en I/O
Latencia de disco ultra baja: μs vs ms
Sin throttling ni límites de EBS
Integración con ClickHouse
Postgres se encuentra con ClickHouse: analítica en tiempo real 100x más rápida. Unifica cargas transaccionales y analíticas.
CDC nativo: sincroniza datos de Postgres a ClickHouse en pocos clics.
Replicación ultrarrápida con latencia de segundos
pg_clickhouse: capa de consultas unificada para construir apps que combinan transacciones y analítica.
Pushdown de consultas integral con pg_clickhouse: JOINs, agregaciones y más.
Postgres enterprise-grade construido con Ubicloud
Postgres diseñado para cargas de trabajo críticas. Sin concesiones en disponibilidad, confiabilidad, seguridad ni en las capacidades estándar de un servicio gestionado. Construido junto a expertos consolidados en Postgres de Ubicloud.
Alta disponibilidad con hasta 2 standbys
Backups automáticos con archivado de WAL a S3
Forks y Point-In-Time-Recovery (PITR)
Cifrado end-to-end y redes privadas
Respaldado por ClickHouse Cloud Trust
Open source primero
Construido con principios open source. Cada componente es de código abierto, sin vendor lock-in y con control total de tu data stack.
Postgres para transacciones
ClickHouse para analítica
PeerDB para CDC
pg_clickhouse para la capa unificada de consultas
Servicio gestionado de Postgres potenciado por Ubicloud
Para conocer más, lee nuestro blog ->->
Por qué los equipos eligen Postgres gestionado por ClickHouse
Cifras reales, cargas de trabajo reales en producción.
ClickHouse's raw performance with the ubiquitous compatibility of Postgres.
ClickHouse is helping us simplify a bold Customer Data Platform architecture by leveraging Postgres as a universal interface.
With pg_clickhouse, ClickHouse becomes a plug-and-play database for virtually any third-party tool (...) It's the best of both worlds.
Multi-terabyte workloads moved, without the operational complexity we expected.
We moved multiple multi-terabyte workloads from RDS and Aurora to ClickHouse Postgres with hands-on support from the ClickHouse team.
Given the scale and complexity of our cybersecurity data sources, reliability and price-performance were critical (...) The team has been a great partner across several complex deployments.
Data stack unificado
Combina Postgres para transacciones con ClickHouse para analítica y obtén un rendimiento y escalabilidad líderes en la industria con una mínima sobrecarga operativa.
Un patrón arquitectónico adoptado por miles de compañías como GitLab, Cloudflare, Instacart y LangChain.
Unlock up to 10× faster Postgres performance with NVMe storage built for I/O-intensive workloads. Microsecond-level latency and millions of IOPS eliminate disk bottlenecks for high-throughput transactional applications.
Unlike traditional SSDs that cap out at a few hundred thousand IOPS, NVMe scales effortlessly, delivering lower tail latencies and faster system operations like VACUUM, checkpoints, and logical replication.
High availability is built in by design, with up to two dedicated standby instances reserved exclusively for HA. Read replicas are offered separately to preserve reliability. Automatic backups and point-in-time recovery (PITR) with WAL archiving ensure robust disaster recovery.
Replicate Postgres data to ClickHouse in real time to unlock up to 100× faster analytics. With replication latency as low as a few seconds, your data is analytics-ready almost immediately.
The pipeline supports both initial snapshots for existing datasets and CDC-based incremental updates. It’s powered by the ClickPipes Postgres CDC connector, proven in production by hundreds of enterprises moving hundreds of terabytes per month.
Coming next: more native CDC capabilities, including sub-second replication latency, reliable slot flushing through ongoing transaction replication, and other enhancements, exclusive to Postgres managed by ClickHouse.
Query ClickHouse directly from Postgres using the pg_clickhouse extension. No proxies, no new query layer to manage. Postgres becomes a single interface for both transactions and analytics.
Queries are transparently pushed down to ClickHouse for maximum performance, supporting joins, filters, aggregations, and functions. Today, 14 of 22 TPC-H queries are fully pushed down, delivering 60×+ speedups.
Pushdown support continues to expand to CTEs, window functions, and more, enabling fast analytics from the Postgres layer while ClickHouse handles execution behind the scenes.
Todo lo que necesitas, desde el primer día
Postgres enterprise
- Point in time recovery (PITR)
- Backups automatizados
- Réplicas de lectura con failover más rápido
- Connection pooling
- Actualizaciones de versión mayor
Integración con ClickHouse
- Extensión pg_clickhouse
- CDC vía ClickPipes
- Pushdown de consultas (JOINs, AGGs)
- Logical Replication v2Pronto
- Custom output pluginPronto
Experiencia de desarrollo
- Aprovisionamiento en un clic
- Consola de ClickHouse Cloud
- monitoreo->monitorización
- Query Performance Insights
- Soporte de API y TerraformPronto