Issues

• Optimize Away non-Materialized remote subqueries

  enhancementpushdownsql
  ClickHouse/pg_clickhouse#387 · Filter by author theory opened on Oct 1, 2026

• Bound uuid and timestamptz parameters deparse to invalid ClickHouse types under a generic plan

  data types
  ClickHouse/pg_clickhouse#386 · Filter by author m24130 opened on Sep 28, 2026
  

• Document how to correlate a foreign scan with system.query_log

  documentationdriversenhancement
  Feature

  ClickHouse/pg_clickhouse#383 · Filter by author litkhai opened on Sep 27, 2026
  1

• Add IMPORT FOREIGN SCHEMA options to selectively alter data types

  data typesenhancement
  Feature

  ClickHouse/pg_clickhouse#380 · Filter by author theory opened on Sep 25, 2026

• Push Down regr_ Functions

  enhancementfunctionspushdown
  Feature

  ClickHouse/pg_clickhouse#379 · Filter by author theory opened on Sep 25, 2026

• Push down joins against an aggregated IN (SELECT … GROUP BY … HAVING) subquery (TPC-H Q18 shape)

  enhancementpushdownsql
  Feature

  ClickHouse/pg_clickhouse#378 · Filter by author litkhai opened on Sep 25, 2026
  

• Push down multidimensional array slice expressions

  operatorspushdown
  Bug

  ClickHouse/pg_clickhouse#375 · Filter by author theory opened on Sep 23, 2026

• Add support for asynchronous fetching, the async_capable table option

  enhancementplanner
  ClickHouse/pg_clickhouse#294 · Filter by author theory opened on Jun 24, 2026
  1

• ORDER BY pushdown ignores sort-order semantics mismatch (text collation, UUID) — merge joins fail with "mergejoin input data is out of order", wrong-results risk

  bugpushdown
  Task

  ClickHouse/pg_clickhouse#276 · Filter by author iskakaushik opened on Jun 13, 2026
  3

• Push down all JOIN expressions as JOIN expressions

  enhancementpushdown
  Feature

  ClickHouse/pg_clickhouse#253 · Filter by author theory opened on May 15, 2026

• Idea: Incorporate ClickHouse ordering into query planner?

  enhancement
  Feature

  ClickHouse/pg_clickhouse#251 · Filter by author theory opened on May 14, 2026

• Support JSON/JSONB #> array and #>> array path operators

  data typesoperators
  Feature

  ClickHouse/pg_clickhouse#248 · Filter by author theory opened on May 11, 2026
  1

• Add Upgrade Test

  qualityworkflow
  Feature

  ClickHouse/pg_clickhouse#243 · Filter by author theory opened on May 8, 2026

• Add column case option to IMPORT FOREIGN SCHEMA

  enhancementsql
  Feature

  ClickHouse/pg_clickhouse#236 · Filter by author theory opened on May 8, 2026
  

• Test Against misbehaving Mock ClickHouse

  help wantedquality
  Task

  ClickHouse/pg_clickhouse#194 · Filter by author theory opened on Apr 7, 2026

• Map All Postgres Operators

  enhancementfunctionspushdownsql
  Task

  ClickHouse/pg_clickhouse#168 · Filter by author theory opened on Apr 1, 2026

• Support JSONB Subscripting

  data typesenhancementpushdown
  Feature

  ClickHouse/pg_clickhouse#166 · Filter by author theory opened on Apr 1, 2026

• Test and if necessary repair issues inserting NULL to get a default value when a column has an explicit DEFAULT

  data typesdrivers
  Task

  ClickHouse/pg_clickhouse#148 · Filter by author theory opened on Feb 5, 2026

• EXPLAIN VERBOSE "FDW Time" does not look right

  benchmarksbugquality
  Bug

  ClickHouse/pg_clickhouse#144 · Filter by author theory opened on Feb 3, 2026

• Improve Cost Discrimination for Aggregate Queries

  plannerpushdown
  Task

  ClickHouse/pg_clickhouse#132 · Filter by author theory opened on Jan 21, 2026

• Implement the AnalyzeForeignTable Callback

  enhancementplanner
  Task

  ClickHouse/pg_clickhouse#131 · Filter by author theory opened on Jan 21, 2026

• Add support for optionally fetching actual remote cost estimates

  plannerpushdown
  Feature

  ClickHouse/pg_clickhouse#129 · Filter by author theory opened on Jan 21, 2026

• Feature Request: Create extension container image for e.g. CNPG

  distribution
  Feature

  ClickHouse/pg_clickhouse#96 · Filter by author ibotty opened on Dec 14, 2025
  1

• Decide how to handle Aggregate function combinators

  aggregatesfunctionsinterfacespushdownsql
  Task

  ClickHouse/pg_clickhouse#88 · Filter by author theory opened on Dec 10, 2025

• Add version verification script/workflow

  distributionquality
  Task

  ClickHouse/pg_clickhouse#86 · Filter by author theory opened on Dec 10, 2025