Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: vincent(dot)moreau(at)leroymerlin(dot)fr
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3
Date: 2007-03-13 10:11:17
Message-ID: 20070313101117.GA98241@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Mar 13, 2007 at 09:19:47AM +0100, vincent(dot)moreau(at)leroymerlin(dot)fr wrote:
> Is there an option in the 8.2.3 to change in order to have the same
> execution plan than before ?

Let's see if we can figure out why 8.2.3 is choosing a bad plan.
Have you run ANALYZE on the tables in 8.2.3? Could you post the
query and the complete output of EXPLAIN ANALYZE (preferably without
wrapping) for both versions?

--
Michael Fuhr

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message femski 2007-03-13 10:55:12 Postgres batch write very slow - what to do
Previous Message vincent.moreau 2007-03-13 08:19:47 Execution plan changed after upgrade from 7.3.9 to 8.2.3