From: Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
To: 'Kohei KaiGai' <kaigai@kaigai.gr.jp>
Cc: 'Shigeru HANADA' <shigeru.hanada@gmail.com>
Cc: 'PostgreSQL-development' <pgsql-hackers@postgresql.org>
Subject: Re: pgsql_fdw in contrib
Date: Tue, 31 Jul 2012 21:28:27 +0900
Message-ID: <002d01cd6f17$fcb00f20$f6102d60$@lab.ntt.co.jp> (raw)
In-Reply-To: <CADyhKSXFtPTtgcTa_c3CCyOGYwSaeVrdypLRtCPTRpgQNkUrnw@mail.gmail.com>
References: <4FD9D947.1020803@gmail.com>
<CADyhKSXs3d-2mvM=5c_GpehQd_nULL-GbGggLVeVKNn5R6odjA@mail.gmail.com>
<CADyhKSViO=i5tMQWS=bvAdkY6ugZs9p7Cd-sdCrc3jRPeZjD8g@mail.gmail.com>
<002301cd6016$971671f0$c54355d0$@lab.ntt.co.jp>
<CADyhKSXFtPTtgcTa_c3CCyOGYwSaeVrdypLRtCPTRpgQNkUrnw@mail.gmail.com>
Hi KaiGai-san,
Sorry about the delay in answering. I have been swamped with another thing
lately.
> BTW, your patch does not make sense in my environment that is just
> after initdb without any parameter customizing. Could you give us
> the step to reproduce the Nested-Loop plan from Hash-Join?
I examined both the Nested-Loop and Hash-Join plans by using the enable_xxxxx
options, and found that their total costs are almost equal. The result might
depend on the execution environment (My environment is Linux 2.6.18 on x86_64.).
I think it is preferable to use the enable_xxxxx options for this regression
test like src/test/regress/sql/join.sql.
Thanks,
Best regards,
Etsuro Fujita
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: fujita.etsuro@lab.ntt.co.jp, kaigai@kaigai.gr.jp, shigeru.hanada@gmail.com
Subject: Re: pgsql_fdw in contrib
In-Reply-To: <002d01cd6f17$fcb00f20$f6102d60$@lab.ntt.co.jp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox