Re: Optimization for updating foreign tables in Postgres FDW

Поиск
Список
Период
Сортировка
Искать
От
Etsuro Fujita
Тема
Re: Optimization for updating foreign tables in Postgres FDW
Дата
Msg-id
540D8FEC.3000504@lab.ntt.co.jp
Ответ на
Список
Дерево обсуждения
Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Robert Haas <robertmhaas@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Shigeru Hanada <shigeru.hanada@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Shigeru Hanada <shigeru.hanada@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Albe Laurenz <laurenz.albe@wien.gv.at>
Re: Optimization for updating foreign tables in Postgres FDW Robert Haas <robertmhaas@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Albe Laurenz <laurenz.albe@wien.gv.at>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Shigeru Hanada <shigeru.hanada@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Robert Haas <robertmhaas@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Tom Lane <tgl@sss.pgh.pa.us>
Re: Optimization for updating foreign tables in Postgres FDW Tom Lane <tgl@sss.pgh.pa.us>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Shigeru Hanada <shigeru.hanada@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Albe Laurenz <laurenz.albe@wien.gv.at>
Re: Optimization for updating foreign tables in Postgres FDW Albe Laurenz <laurenz.albe@wien.gv.at>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Albe Laurenz <laurenz.albe@wien.gv.at>
Re: Optimization for updating foreign tables in Postgres FDW Stephen Frost <sfrost@snowman.net>
Re: Optimization for updating foreign tables in Postgres FDW Tom Lane <tgl@sss.pgh.pa.us>
Re: Optimization for updating foreign tables in Postgres FDW Stephen Frost <sfrost@snowman.net>
Re: Optimization for updating foreign tables in Postgres FDW Albe Laurenz <laurenz.albe@wien.gv.at>
Re: Optimization for updating foreign tables in Postgres FDW Tom Lane <tgl@sss.pgh.pa.us>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Albe Laurenz <laurenz.albe@wien.gv.at>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Stephen Frost <sfrost@snowman.net>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Thom Brown <thom@linux.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Rushabh Lathia <rushabh.lathia@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Robert Haas <robertmhaas@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Thom Brown <thom@linux.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Odd behavior in foreign table modification (Was: Re: Optimization for updating foreign tables in Postgres FDW) Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Odd behavior in foreign table modification (Was: Re: Optimization for updating foreign tables in Postgres FDW) Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Odd behavior in foreign table modification (Was: Re: Optimization for updating foreign tables in Postgres FDW) Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Odd behavior in foreign table modification (Was: Re: Optimization for updating foreign tables in Postgres FDW) Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Odd behavior in foreign table modification (Was: Re: Optimization for updating foreign tables in Postgres FDW) Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Odd behavior in foreign table modification (Was: Re: Optimization for updating foreign tables in Postgres FDW) Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Odd behavior in foreign table modification (Was: Re: Optimization for updating foreign tables in Postgres FDW) Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Odd behavior in foreign table modification (Was: Re: Optimization for updating foreign tables in Postgres FDW) Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Rushabh Lathia <rushabh.lathia@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Rushabh Lathia <rushabh.lathia@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Rushabh Lathia <rushabh.lathia@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Rushabh Lathia <rushabh.lathia@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Rushabh Lathia <rushabh.lathia@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Rushabh Lathia <rushabh.lathia@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Rushabh Lathia <rushabh.lathia@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Rushabh Lathia <rushabh.lathia@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Rushabh Lathia <rushabh.lathia@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Rushabh Lathia <rushabh.lathia@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Rushabh Lathia <rushabh.lathia@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Robert Haas <robertmhaas@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Rushabh Lathia <rushabh.lathia@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Robert Haas <robertmhaas@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Robert Haas <robertmhaas@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Robert Haas <robertmhaas@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Tom Lane <tgl@sss.pgh.pa.us>
Re: Optimization for updating foreign tables in Postgres FDW Robert Haas <robertmhaas@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Tom Lane <tgl@sss.pgh.pa.us>
Re: Optimization for updating foreign tables in Postgres FDW Robert Haas <robertmhaas@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Robert Haas <robertmhaas@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Thom Brown <thom@linux.com>
Re: Optimization for updating foreign tables in Postgres FDW Michael Paquier <michael.paquier@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Noah Misch <noah@leadboat.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Michael Paquier <michael.paquier@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Noah Misch <noah@leadboat.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Robert Haas <robertmhaas@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Rushabh Lathia <rushabh.lathia@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Michael Paquier <michael.paquier@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Michael Paquier <michael.paquier@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Robert Haas <robertmhaas@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Robert Haas <robertmhaas@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Michael Paquier <michael.paquier@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Michael Paquier <michael.paquier@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Michael Paquier <michael.paquier@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Michael Paquier <michael.paquier@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Noah Misch <noah@leadboat.com>
Re: Optimization for updating foreign tables in Postgres FDW Michael Paquier <michael.paquier@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Michael Paquier <michael.paquier@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Michael Paquier <michael.paquier@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Optimization for updating foreign tables in Postgres FDW Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Optimization for updating foreign tables in PostgresFDW Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: [HACKERS] Optimization for updating foreign tables in Postgres FDW Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Optimization for updating foreign tables in PostgresFDW Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: [HACKERS] Optimization for updating foreign tables in Postgres FDW Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Optimization for updating foreign tables in PostgresFDW Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: [HACKERS] Optimization for updating foreign tables in Postgres FDW Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Optimization for updating foreign tables in Postgres FDW Michael Paquier <michael.paquier@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Michael Paquier <michael.paquier@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Robert Haas <robertmhaas@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Michael Paquier <michael.paquier@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Michael Paquier <michael.paquier@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Michael Paquier <michael.paquier@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Robert Haas <robertmhaas@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Thom Brown <thom@linux.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Rushabh Lathia <rushabh.lathia@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Rushabh Lathia <rushabh.lathia@gmail.com>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Optimization for updating foreign tables in Postgres FDW Pavel Stehule <pavel.stehule@gmail.com>
(2014/09/08 16:18), Albe Laurenz wrote:
> I wrote:
>> I gave it a spin and could not find any undesirable behaviour, and the
>> output of EXPLAIN ANALYZE looks like I'd expect.

Thank you for the review!

>> I noticed that you use the list length of fdw_private to check if
>> the UPDATE or DELETE is pushed down to the remote server or not.
>>
>> While this works fine, I wonder if it wouldn't be better to have some
>> explicit flag in fdw_private for that purpose.  Future modifications that
>> change the list length might easily overlook that it is used for this
>> purpose, thereby breaking the code.

>> Other than that it looks alright to me.

> Maybe I should have mentioned that I have set the patch to "Waiting for Author"
> because I'd like to hear your opinion on that, but I'm prepared to set it
> to "Ready for Committer" soon.

I agree with you on that point.  So, I've updated the patch to have the 
explicit flag, as you proposed.  Attached is the updated version of the 
patch.  In this version, I've also revised code and its comments a bit.

Sorry for the delay.

Best regards,
Etsuro Fujita
В списке pgsql-hackers по дате отправления
От: Mitsumasa KONDO
Дата:
От: Michael Paquier
Дата:
FAQ