Re: Transactions involving multiple postgres foreign servers

Поиск
Список
Период
Сортировка
Искать
От
vinayak
Тема
Re: Transactions involving multiple postgres foreign servers
Дата
Msg-id
addd9075-402f-4af5-777d-1288c75758b0@lab.ntt.co.jp
Ответ на
Список
Дерево обсуждения
Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Tom Lane <tgl@sss.pgh.pa.us>
Re: Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: Transactions involving multiple postgres foreign servers Tom Lane <tgl@sss.pgh.pa.us>
Re: Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: Transactions involving multiple postgres foreign servers Tom Lane <tgl@sss.pgh.pa.us>
Re: Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Kevin Grittner <kgrittn@ymail.com>
Re: Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: Transactions involving multiple postgres foreign servers Kevin Grittner <kgrittn@ymail.com>
Re: Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: Transactions involving multiple postgres foreign servers Kevin Grittner <kgrittn@ymail.com>
Re: Transactions involving multiple postgres foreign servers Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Transactions involving multiple postgres foreign servers Michael Paquier <michael.paquier@gmail.com>
Re: Transactions involving multiple postgres foreign servers Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Transactions involving multiple postgres foreign servers Michael Paquier <michael.paquier@gmail.com>
Re: Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Heikki Linnakangas <hlinnaka@iki.fi>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: Transactions involving multiple postgres foreign servers Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: Transactions involving multiple postgres foreign servers Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: Transactions involving multiple postgres foreign servers Amit Kapila <amit.kapila16@gmail.com>
Re: Transactions involving multiple postgres foreign servers Amit Kapila <amit.kapila16@gmail.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Transactions involving multiple postgres foreign servers Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Transactions involving multiple postgres foreign servers Vinayak Pokale <vinpokale@gmail.com>
Re: Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers vinayak <Pokale_Vinayak_q3@lab.ntt.co.jp>
Re: Transactions involving multiple postgres foreign servers vinayak <Pokale_Vinayak_q3@lab.ntt.co.jp>
Re: Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: Transactions involving multiple postgres foreign servers Michael Paquier <michael.paquier@gmail.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Michael Paquier <michael.paquier@gmail.com>
Re: Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: Transactions involving multiple postgres foreign servers Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: Transactions involving multiple postgres foreign servers Bruce Momjian <bruce@momjian.us>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: Transactions involving multiple postgres foreign servers Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Transactions involving multiple postgres foreignservers vinayak <Pokale_Vinayak_q3@lab.ntt.co.jp>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreignservers vinayak <Pokale_Vinayak_q3@lab.ntt.co.jp>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreignservers vinayak <Pokale_Vinayak_q3@lab.ntt.co.jp>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreignservers Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Transactions involving multiple postgres foreignservers vinayak <Pokale_Vinayak_q3@lab.ntt.co.jp>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreignservers vinayak <Pokale_Vinayak_q3@lab.ntt.co.jp>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Vinayak Pokale <pokale_vinayak_q3@lab.ntt.co.jp>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreignservers Stas Kelvich <s.kelvich@postgrespro.ru>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreignservers Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreignservers Stas Kelvich <s.kelvich@postgrespro.ru>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreignservers Stas Kelvich <s.kelvich@postgrespro.ru>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Daniel Gustafsson <daniel@yesql.se>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Antonin Houska <ah@cybertec.at>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Antonin Houska <ah@cybertec.at>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
RE: [HACKERS] Transactions involving multiple postgres foreignservers "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreignservers David Steele <david@pgmasters.net>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
RE: [HACKERS] Transactions involving multiple postgres foreignservers "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
RE: [HACKERS] Transactions involving multiple postgres foreignservers "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Transactions involving multiple postgres foreign servers Michael Paquier <michael.paquier@gmail.com>
Re: Transactions involving multiple postgres foreign servers Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Transactions involving multiple postgres foreign servers Michael Paquier <michael.paquier@gmail.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Michael Paquier <michael.paquier@gmail.com>
Re: Transactions involving multiple postgres foreign servers Amit Kapila <amit.kapila16@gmail.com>
Re: Transactions involving multiple postgres foreign servers Amit Kapila <amit.kapila16@gmail.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Robert Haas <robertmhaas@gmail.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Kevin Grittner <kgrittn@ymail.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Transactions involving multiple postgres foreign servers Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>

On 2016/09/07 10:54, vinayak wrote:

Thanks for the clarification. I had added pg_fdw_xact_resolver() to resolve any transactions which can not be resolved immediately after they were prepared. There was a comment from Kevin (IIRC) that leaving transactions unresolved on the foreign server keeps the resources locked on those servers. That's not a very good situation. And nobody but the initiating server can resolve those. That functionality is important to make it a complete 2PC solution. So, please consider it to be included in your first set of patches.
The attached patch included pg_fdw_xact_resolver.

The attached patch includes the documentation.

Regards,
Vinayak Pokale
NTT Open Source Software Center
В списке pgsql-hackers по дате отправления
От: Amit Langote
Дата:
От: Etsuro Fujita
Дата:
FAQ