| From: | Shigeru HANADA <shigeru(dot)hanada(at)gmail(dot)com> |
|---|---|
| To: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Kohei KaiGai <kaigai(at)kaigai(dot)gr(dot)jp>, Martijn van Oosterhout <kleptog(at)svana(dot)org>, Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp>, Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com> |
| Subject: | Re: pgsql_fdw, FDW for PostgreSQL server |
| Date: | 2012-04-06 11:44:52 |
| Message-ID: | 4F7ED734.2020109@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
(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
| Attachment | Content-Type | Size |
|---|---|---|
| pgsql_fdw_rowproc_v1.patch | text/plain | 49.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cousin Marc | 2012-04-06 12:47:39 | Re: [PATCH] lock_timeout and common SIGALRM framework |
| Previous Message | Shigeru HANADA | 2012-04-06 10:39:36 | Re: pgsql_fdw, FDW for PostgreSQL server |