clickhousedb_fdw icon indicating copy to clipboard operation
clickhousedb_fdw copied to clipboard

Support limit pushdown

Open davidpsv17 opened this issue 4 years ago • 0 comments

In some cases after grouping by certain column(s) ClickHouse still might return a lot of rows, so performing LIMIT on clickhouse side will be beneficial.

EXPLAIN VERBOSE select city from t1 LIMIT 10; QUERY PLAN

Limit (cost=0.00..0.00 rows=1 width=32) Output: city -> Foreign Scan on public.t1 (cost=0.00..0.00 rows=0 width=32) Output: city Remote SQL: SELECT city FROM "default".t1 (5 rows)

davidpsv17 avatar Jun 17 '20 09:06 davidpsv17