Avoid retrieving dummy NULL columns in postgres_fdw.
Tom Lane <tgl@sss.pgh.pa.us>
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 ...
Files
| Path | Change | +/− |
|---|---|---|
| contrib/postgres_fdw/deparse.c | modified | +69 −26 |
| contrib/postgres_fdw/expected/postgres_fdw.out | modified | +131 −119 |
| contrib/postgres_fdw/postgres_fdw.c | modified | +88 −67 |
| contrib/postgres_fdw/postgres_fdw.h | modified | +10 −5 |
| contrib/postgres_fdw/sql/postgres_fdw.sql | modified | +3 −1 |