| From: | Shigeru Hanada <shigeru(dot)hanada(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>, Martijn van Oosterhout <kleptog(at)svana(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Kohei KaiGai <kaigai(at)kaigai(dot)gr(dot)jp> |
| Subject: | Re: pgsql_fdw, FDW for PostgreSQL server |
| Date: | 2011-11-15 16:55:08 |
| Message-ID: | 4EC2996C.8040401@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
Attached are revised version of pgsql_fdw patches.
fdw_helper_funcs_v2.patch provides some functions which would be useful
to implement FDW, and document about FDW helper functions including
those which exist in 9.1. They are not specific to pgsql_fdw, so I
separated it from pgsql_fdw patch.
pgsql_fdw_v4.patch provides a FDW for PostgreSQL. This patch requires
fdw_helper_funcs_v2.patch has been applied. Changes done since last
version are:
* Default of fetch_count option is increased to 10000, as suggested by
Pavel Stehule.
* Remove unnecessary NULL check before PQresultStatus.
* Evaluate all conditions on local side even if some of them has been
pushed down to remote side, to ensure that results are correct.
* Use fixed costs for queries which contain external parameter, because
such query can't be used in EXPLAIN command.
Regards,
--
Shigeru Hanada
| Attachment | Content-Type | Size |
|---|---|---|
| fdw_helper_funcs_v2.patch | text/plain | 12.8 KB |
| pgsql_fdw_v4.patch | text/plain | 103.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2011-11-15 16:55:49 | Re: FlexLocks |
| Previous Message | Jaime Casanova | 2011-11-15 16:24:29 | Re: patch : Allow toast tables to be moved to a different tablespace |