Postgres Pro
Downloads
Home   >   mailing lists

Re: Identical DB's, different execution plans - Mailing list pgsql-performance

From Tom Lane
Subject Re: Identical DB's, different execution plans
Date
Msg-id 15191.1222706521@sss.pgh.pa.us
Whole thread Raw
In response to Identical DB's, different execution plans  (Doug Eck <deck1@yahoo.com>)
List pgsql-performance
Tree view 
Doug Eck <deck1@yahoo.com> writes:
> Any ideas as to what could the first db to opt for the slower subquery rather than the merge?

Not from the information given.  Presumably db1 thinks that the
mergejoin plan would be slower, but why it thinks that isn't clear yet.
Try setting enable_nestloop = off (and enable_hashjoin = off if it then
wants a hashjoin) and then post the EXPLAIN ANALYZE results.

            regards, tom lane

pgsql-performance by date:

Previous
From: Doug Eck
Date:
Subject: Identical DB's, different execution plans
Next
From: Doug Eck
Date:
Subject: Re: Identical DB's, different execution plans