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
Ответ на
Список
Дерево обсуждения
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
Дата:
От: Stephen Frost
Дата:
FAQ