EDB Postgres AI for ClickHouse® compatibility v26.3

Platform compatibility

  • RHEL 8, 9, and 10, and Rocky Linux 9 and 10, on x86_64, aarch64, and ppc64le.
  • Debian 13 (trixie) on amd64, arm64, and ppc64el.

System requirements

Minimum recommended hardware per node:

Single-nodeCluster node
CPU16 cores16 cores
RAM128 GB (8 GB per core)128 GB (8 GB per core)
Storage100 GB (NVMe preferred)100 GB (NVMe preferred)

For production sizing guidance, see the ClickHouse sizing and hardware recommendations.

WarehousePG

  • WarehousePG 6.x or later.

pg_stat_ch

These are the operating systems of the Postgres host, independent of the platform requirements for ClickHouse® itself.

PlatformPackage formatArchitecturesPostgres distributionsPostgres versions
Rocky Linux 9RPMx86-64, arm64Community Postgres, EDB Postgres Extended Server, EDB Postgres Advanced Server16, 17, 18
Debian 12 (bookworm)DEBamd64, arm64Community Postgres16, 17, 18
Debian 12 (bookworm)DEBamd64, arm64EDB Postgres Extended Server, EDB Postgres Advanced Server16, 17
Debian 13 (trixie)DEBamd64, arm64Community Postgres16, 17, 18

EDB publishes no EDB Postgres Advanced Server or EDB Postgres Extended Server packages for Debian 13. See Monitoring Postgres with pg_stat_ch.

pg_clickhouse

These are the operating systems of the Postgres host, independent of the platform requirements for ClickHouse itself.

PlatformPackage formatArchitecturesPostgres distributionsPostgres versions
Rocky Linux 9RPMx86-64, arm64Community Postgres, EDB Postgres Extended Server, EDB Postgres Advanced Server16, 17, 18
Debian 12 (bookworm)DEBamd64, arm64Community Postgres, EDB Postgres Extended Server, EDB Postgres Advanced Server16, 17, 18
Debian 13 (trixie)DEBamd64, arm64Community Postgres16, 17, 18

EDB publishes no EDB Postgres Advanced Server or EDB Postgres Extended Server packages for Debian 13. See Querying ClickHouse from Postgres with pg_clickhouse.

Apache Iceberg®

Iceberg format versionReadWrite
v1YesNo
v2 (position deletes)YesNo
v2 (equality deletes)YesNo
v3 (deletion vectors)NoNo

Write support for Iceberg isn't yet available. See Known issues.

Object storage

ProviderTable engines
Amazon S3IcebergS3, DeltaLake, S3
Azure Blob StorageIcebergAzureBlobStorage, AzureBlobStorage
HDFSIcebergHDFS, HDFS
Local filesystemIcebergLocal, File