| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql: Avoid retrieving dummy NULL columns in postgres_fdw. |
| Date: | 2013-03-22 04:31:30 |
| Message-ID: | E1UItda-0008Jg-E8@gemulon.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Avoid retrieving dummy NULL columns in postgres_fdw.
This should provide some marginal overall savings, since it surely takes
many more cycles for the remote server to deal with the NULL columns than
it takes for postgres_fdw not to emit them. But really the reason is to
keep the emitted queries from looking quite so silly ...
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/e690b9515072fd7767fdeca5c54166f6a77733bc
Modified Files
--------------
contrib/postgres_fdw/deparse.c | 95 +++++++---
contrib/postgres_fdw/expected/postgres_fdw.out | 250 +++++++++++++-----------
contrib/postgres_fdw/postgres_fdw.c | 155 +++++++++-------
contrib/postgres_fdw/postgres_fdw.h | 15 +-
contrib/postgres_fdw/sql/postgres_fdw.sql | 4 +-
5 files changed, 301 insertions(+), 218 deletions(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2013-03-22 12:05:44 | pgsql: Change commit_delay to be SUSET for 9.3+ |
| Previous Message | Tom Lane | 2013-03-21 23:44:41 | pgsql: Redo postgres_fdw's planner code so it can handle parameterized |