Re: [HACKERS] FDW handling count(*) through AnalyzeForeignTable or other constant time push-down

2016-02-26 Thread Gabe F. Rudy
proposals. Gabe -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Thursday, February 25, 2016 11:21 PM To: Gabe F. Rudy Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] FDW handling count(*) through AnalyzeForeignTable or other constant time push-down &qu

[HACKERS] FDW handling count(*) through AnalyzeForeignTable or other constant time push-down

2016-02-25 Thread Gabe F. Rudy
Hey all, I'm building a FDW around a column-store backend (similar to CStore but for genomic data!). I have tables in the billions of rows, and have a common query pattern of asking for the table size (i.e. SELECT COUNT(*) FROM big_fdw_table; ). This is a read-optimized system in which I know