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
Ответ на
Re: Optimization for updating foreign tables in Postgres
FDW (Albe Laurenz)
Список
Дерево обсуждения
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) Robert Haas <robertmhaas@gmail.com>
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) Robert Haas <robertmhaas@gmail.com>
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) Robert Haas <robertmhaas@gmail.com>
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) Robert Haas <robertmhaas@gmail.com>
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 по дате отправления