Re: [HACKERS] postgres_fdw bug in 9.6
От
Etsuro Fujita
Тема
Re: [HACKERS] postgres_fdw bug in 9.6
Дата
Msg-id
79b98e30-4d38-7deb-f1fb-bc0bc589a958@lab.ntt.co.jp
Ответ на
Re: [HACKERS] postgres_fdw bug in 9.6 (Etsuro Fujita)
Список
Дерево обсуждения
postgres_fdw bug in 9.6 Jeff Janes <jeff.janes@gmail.com>
Re: postgres_fdw bug in 9.6 Tom Lane <tgl@sss.pgh.pa.us>
Re: postgres_fdw bug in 9.6 Robert Haas <robertmhaas@gmail.com>
Re: postgres_fdw bug in 9.6 Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] postgres_fdw bug in 9.6 Jeff Janes <jeff.janes@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] postgres_fdw bug in 9.6 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 David Steele <david@pgmasters.net>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: postgres_fdw bug in 9.6 Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: postgres_fdw bug in 9.6 Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] postgres_fdw bug in 9.6 Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: postgres_fdw bug in 9.6 Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: postgres_fdw bug in 9.6 Jeff Janes <jeff.janes@gmail.com>
Re: postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] postgres_fdw bug in 9.6 Ryan Murphy <ryanfmurphy@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Ryan Murphy <ryanfmurphy@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] postgres_fdw bug in 9.6 Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] postgres_fdw bug in 9.6 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] postgres_fdw bug in 9.6 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] postgres_fdw bug in 9.6 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] postgres_fdw bug in 9.6 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] postgres_fdw bug in 9.6 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] postgres_fdw bug in 9.6 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] postgres_fdw bug in 9.6 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] postgres_fdw bug in 9.6 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Thomas Munro <thomas.munro@enterprisedb.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 David Steele <david@pgmasters.net>
Re: [HACKERS] postgres_fdw bug in 9.6 Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Jeff Janes <jeff.janes@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] postgres_fdw bug in 9.6 Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
On 2017/03/21 18:40, Etsuro Fujita wrote: > Ok, I'll update the patch. One thing I'd like to revise in addition to > that is (1) add to JoinPathExtraData a flag member to indicate whether > to give the FDW a chance to consider a remote join, which will be set to > true if the joinrel's fdwroutine is not NULL and the fdwroutine's > GetForeignJoinPaths is not NULL, and (2) if the flag is true, save info > to create an alternative local join path, such as hashclauses and > mergeclauses proposed in the patch, into JoinPathExtraData in > add_paths_to_joinrel. This would avoid useless overhead in saving such > info into JoinPathExtraData when we don't give the FDW that chance. Done. Attached is a new version of the patch. Best regards, Etsuro Fujita -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
В списке pgsql-hackers по дате отправления
От: Magnus Hagander
Дата: