pgsql: Avoid retrieving dummy NULL columns in postgres_fdw.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Avoid retrieving dummy NULL columns in postgres_fdw.
Дата
Msg-id E1UItda-0008Jg-E8@gemulon.postgresql.org
обсуждение исходный текст
Список 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(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Redo postgres_fdw's planner code so it can handle parameterized
Следующее
От: Simon Riggs
Дата:
Сообщение: pgsql: Change commit_delay to be SUSET for 9.3+