| From: | "Etsuro Fujita" <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp> |
|---|---|
| To: | "'Kohei KaiGai'" <kaigai(at)kaigai(dot)gr(dot)jp> |
| Cc: | "'Shigeru HANADA'" <shigeru(dot)hanada(at)gmail(dot)com>, "'PostgreSQL-development'" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pgsql_fdw in contrib |
| Date: | 2012-07-31 12:28:27 |
| Message-ID: | 002d01cd6f17$fcb00f20$f6102d60$@lab.ntt.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thom Brown | 2012-07-31 13:06:16 | JSON function reference in docs |
| Previous Message | Amit kapila | 2012-07-31 12:09:06 | [PATCH] Patch to compute Max LSN of Data Pages |