> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-fix-nav-issues.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Managed Postgres

> Fast, scalable, enterprise-grade Postgres backed by NVMe storage with native ClickHouse integration for real-time analytics

export const Image = ({img, alt, size}) => {
  return <Frame>
      <img src={img} alt={alt} />
    </Frame>;
};

export const galaxyOnClick = eventName => () => {
  try {
    if (typeof window !== "undefined" && window.galaxy && eventName) {
      window.galaxy.track(eventName, {
        interaction: "click"
      });
    }
  } catch (e) {}
};

export const BetaBadge = ({link, galaxyTrack, galaxyEvent}) => {
  if (link) {
    return <a href={link} target="_blank" rel="noopener noreferrer" className="betaBadge" onClick={galaxyTrack && galaxyEvent ? galaxyOnClick(galaxyEvent) : undefined}>
                <Icon />
                <span>Beta</span>
            </a>;
  }
  return <div className="betaBadge">
            <Icon />
            <span>
                Beta feature. 
                <u>
                    <a href="/docs/beta-and-experimental-features#beta-features">
                        Learn more.
                    </a>
                </u>
            </span>
        </div>;
};

ClickHouse Managed Postgres is an enterprise-grade managed Postgres service built for performance and scale. Backed by NVMe storage that is physically collocated with compute, it delivers up to 10x faster performance for workloads that are disk-bound compared to alternatives using network-attached storage like EBS.

Built in partnership with [Ubicloud](https://www.ubicloud.com/), whose founding team has a track record of delivering world-class Postgres at Citus Data, Heroku, and Microsoft, Managed Postgres solves the performance challenges that fast-growing applications commonly face: slower ingestion and updates, slow vacuums, increased tail latency, and WAL spikes caused by limited disk IOPS.

<h2 id="nvme-performance">
  NVMe-powered performance
</h2>

Most managed Postgres services use network-attached storage like Amazon EBS, which requires a network round trip for every disk access. This introduces latency measured in milliseconds and limits IOPS, creating bottlenecks for write-heavy or I/O-intensive workloads.

Managed Postgres uses NVMe storage that is physically attached to the same server as your database. This architectural difference delivers:

* **Microsecond-level disk latency** instead of milliseconds
* **10x sustained IOPS limits**<sup>\*</sup> without network bottlenecks
* **Up to 10x faster performance** for disk-bound workloads at the same cost

For Postgres workloads that are primarily throttled by disk IOPS and latency, this translates to faster ingestion, quicker vacuums, lower tail latency, and more predictable performance under load.

<Note>
  Learn how fast Postgres is on NVMe disks from [performance benchmarks](https://clickhouse.com/blog/postgresbench).
</Note>

For local NVMe limits on AWS see [Memory optimized](https://docs.aws.amazon.com/ec2/latest/instancetypes/mo.html#mo_instance-store), [Storage optimized](https://docs.aws.amazon.com/ec2/latest/instancetypes/so.html#so_instance-store), [CPU optimized](https://docs.aws.amazon.com/ec2/latest/instancetypes/gp.html#gp_instance-store).

<h2 id="clickhouse-integration">
  Native ClickHouse integration
</h2>

Managed Postgres integrates natively with ClickHouse to bring transactions and analytics together without complex ETL pipelines.

<h3 id="postgres-replication">
  Postgres to ClickHouse replication
</h3>

Replicate your Postgres data to ClickHouse using the [Postgres CDC connector in ClickPipes](/integrations/clickpipes/postgres/index). The connector handles both initial load and continuous incremental sync, and is battle-tested by hundreds of enterprise customers moving hundreds of terabytes per month.

<h3 id="pg-clickhouse">
  pg\_clickhouse: unified query layer
</h3>

Every Managed Postgres instance comes with the [`pg_clickhouse`](https://github.com/ClickHouse/pg_clickhouse) extension, which lets you query ClickHouse directly from Postgres. Your application can use Postgres as a unified query layer for both transactions and analytics, without needing to connect to multiple databases.

The extension provides comprehensive query pushdown to ClickHouse for efficient execution, including support for filters, joins, semi-joins, aggregations, and functions. Currently, 14 of 22 TPC-H queries are fully pushed down, delivering over 60X performance improvements compared to running the same queries in standard Postgres.

<h2 id="enterprise-reliability">
  Enterprise-grade reliability
</h2>

Managed Postgres provides the reliability and security features that production workloads require.

<h3 id="high-availability">
  High availability
</h3>

Configure up to two standby replicas across different availability zones using quorum-based replication. These standbys are dedicated to high availability and automatic failover, ensuring your database recovers quickly from failures. For read scaling, you can provision separate [read replicas](/products/managed-postgres/read-replicas). See the [High availability](/products/managed-postgres/high-availability) page for configuration details.

<h3 id="backups">
  Backups and recovery
</h3>

Every instance includes automatic backups that support forks and point-in-time recovery. Backups run on [WAL-G](https://github.com/wal-g/wal-g), a well-known open-source tool that handles full backups and continuous WAL archiving to object storage.

<h3 id="security-compliance">
  Security and compliance
</h3>

Managed Postgres is built to meet the same security standards as ClickHouse Cloud:

* **Authentication**: SAML/SSO support
* **Network security**: IP allow-listing, encryption at rest and in transit (TLS 1.3)
* **Access control**: Full superuser access for database administration

<h3 id="open-source">
  Open source foundation
</h3>

Both Postgres and ClickHouse are open-source databases with large, thriving communities. The integration components, including the `pg_clickhouse` extension and the CDC replication powered by PeerDB, are also open source. This foundation ensures no vendor lock-in, giving you full control and long-term flexibility over your data stack.