Re: pgsql_fdw, FDW for PostgreSQL server

Shigeru Hanada <shigeru.hanada@gmail.com>

From: Shigeru HANADA <shigeru.hanada@gmail.com>

To: Albe Laurenz <laurenz.albe@wien.gv.at>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, Kevin Grittner <Kevin.Grittner@wicourts.gov>, Robert Haas <robertmhaas@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>, Kohei KaiGai <kaigai@kaigai.gr.jp>, Martijn van Oosterhout <kleptog@svana.org>, Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>, Hitoshi Harada <umi.tanuki@gmail.com>

Date: 2012-04-06T11:44:52Z

Lists: pgsql-hackers

Attachments

pgsql_fdw_rowproc_v1.patch (text/plain) patch v1

(2012/04/04 15:43), Shigeru HANADA wrote:
> Attached patch contains changes below:
> 
> pgsql_fdw_v19.patch
>    - show context of data conversion error
>    - move codes for fetch_count FDW option to option.c
>      (refactoring)
> pgsql_fdw_pushdown_v12.patch
>    - make deparseExpr function static (refactoring)
> 
> I also attached pgsql_fdw_analyze for only testing the effect of local
> statistics.  It contains both backend's ANALYZE command support and
> pgsql_fdw's ANALYZE support.

Attached patch improves pgsql_fdw so that it uses new libpq row
processor API, and get rid of overhead of SQL-level cursor.  This change
would speed up remote queries without extra memory.

This patch can be applied after pgsql_fdw_pushdown_v12.patch.

Regards,
-- 
Shigeru HANADA