Issues

• round(avg(int), n) pushed down rounds ties to even; Postgres rounds them away from zero

  functionspushdown
  ClickHouse/pg_clickhouse#409 · Filter by author litkhai opened on Oct 14, 2026
  1

• Normalize Numeric (No scale or precision) Values

  bugdata typespushdown
  Bug

  ClickHouse/pg_clickhouse#406 · Filter by author theory opened on Oct 13, 2026

• Drop HTTP driver

  drivers
  ClickHouse/pg_clickhouse#391 · Filter by author theory opened on Oct 5, 2026

• Optimize Away non-Materialized remote subqueries

  enhancementpushdownsql
  ClickHouse/pg_clickhouse#387 · Filter by author theory opened on Oct 1, 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 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

• 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