Skip site navigation (1) Skip section navigation (2)

Re: pgsql_fdw in contrib

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 (view raw or flat)
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



In response to

pgsql-hackers by date

Next:From: Thom BrownDate: 2012-07-31 13:06:16
Subject: JSON function reference in docs
Previous:From: Amit kapilaDate: 2012-07-31 12:09:06
Subject: [PATCH] Patch to compute Max LSN of Data Pages

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group