Re: Odd system-column handling in postgres_fdw join pushdown patch

Поиск
Список
Период
Сортировка
От Etsuro Fujita
Тема Re: Odd system-column handling in postgres_fdw join pushdown patch
Дата
Msg-id 570F0CCB.50008@lab.ntt.co.jp
обсуждение исходный текст
Ответ на Re: Odd system-column handling in postgres_fdw join pushdown patch  (Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>)
Ответы Re: Odd system-column handling in postgres_fdw join pushdown patch
Список pgsql-hackers
On 2016/04/14 12:04, Etsuro Fujita wrote:
> On 2016/04/14 4:57, Robert Haas wrote:
>> 2. When a join is pushed down, deparse system columns using something
>> like "CASE WHEN r1.* IS NOT NULL THEN 0 END", except for the table OID
>> column, which gets deparsed with the table OID in place of 0.  This
>> delivers the correct behavior in the presence of outer joins.

> I think that that would cause useless data transfer for such culumns.
> Why not set values locally for such columns?

At least for the table OID.

Best regards,
Etsuro Fujita





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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Performance degradation in commit 6150a1b0
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: Support for N synchronous standby servers - take 2