ethanryl

I have the same problem that my query cannot be pushed down.

EXPLAIN VERBOSE SELECT count(bbl) FROM tax_bills_nyc; QUERY PLAN -------------------------------------------------------------------------------------------------------------------------------------- Aggregate (cost=0.00..0.01 rows=1 width=8) Output: count(bbl) -> Foreign Scan on public.tax_bills_nyc (cost=0.00..0.00 rows=0 width=8) Output: bbl, owner_name, address, tax_class, tax_rate, emv,...

EXPLAIN VERBOSE SELECT count(*) FROM tax_bills_nyc; QUERY PLAN -------------------------------------------------------------------------------------------------------------------------------------- Aggregate (cost=0.00..0.01 rows=1 width=8) Output: count(*) -> Foreign Scan on public.tax_bills_nyc (cost=0.00..0.00 rows=0 width=0) Output: bbl, owner_name, address, tax_class, tax_rate, emv,...

I believe you can beat it,Please let me know if there is any new progress. thanks for you. ------------------ 原始邮件 ------------------ 发件人: "Ibrar Ahmed"; 发送时间: 2019年6月11日(星期二) 晚上8:51 收件人: "Percona-Lab/clickhousedb_fdw"; 抄送:...

Hello, about the problem that clickhousedb_fdw cannot be pushed down, how is the research going. ------------------ 原始邮件 ------------------ 发件人: "Ibrar Ahmed"; 发送时间: 2019年6月11日(星期二) 晚上8:59 收件人: "Percona-Lab/clickhousedb_fdw"; 抄送: "下一个明天";"Comment"; 主题: Re:...

hi，ibrarahmad、harris-chiu The problem has been solved. I set clickhousedb_fdw.join_pushdown_safe=on and then the SQL can be pushed down. Thank you very much.