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

Re: Identical DB's, different execution plans

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Doug Eck <deck1(at)yahoo(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Identical DB's, different execution plans
Date: 2008-09-29 16:42:01
Message-ID: 15191.1222706521@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Doug Eck <deck1(at)yahoo(dot)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

In response to

pgsql-performance by date

Next:From: Doug EckDate: 2008-09-29 18:18:45
Subject: Re: Identical DB's, different execution plans
Previous:From: Doug EckDate: 2008-09-29 16:00:02
Subject: Identical DB's, different execution plans

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