Horton

Re: pgsql_fdw in contrib

Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>

View thread
From: "Etsuro Fujita" <fujita.etsuro@lab.ntt.co.jp>
To: "'Kohei KaiGai'" <kaigai@kaigai.gr.jp>
Cc: "'Shigeru HANADA'" <shigeru.hanada@gmail.com>, "'PostgreSQL-development'" <pgsql-hackers@postgresql.org>
Date: 2012-07-31T12:28:27Z
Lists: pgsql-hackers 
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