Re: Optimization for updating foreign tables in Postgres FDW

Поиск
Список
Период
Сортировка
Искать
От
Etsuro Fujita
Тема
Re: Optimization for updating foreign tables in Postgres FDW
Дата
Msg-id
570B5D40.6080203@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>
On 2016/04/11 12:30, Michael Paquier wrote:
> +                       if ((cancel = PQgetCancel(entry->conn)))
> +                       {
> +                           PQcancel(cancel, errbuf, sizeof(errbuf));
> +                           PQfreeCancel(cancel);
> +                       }
> Wouldn't it be better to issue a WARNING here if PQcancel does not succeed?

Seems like a good idea.  Attached is an updated version of the patch.

Thanks for the review!

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