Re: Different execution plan - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Different execution plan
Date
Msg-id dcc563d10809221419k25e5a75i1e95984ef382f7f2@mail.gmail.com
Whole thread Raw
In response to Re: Different execution plan  ("Sabin Coanda" <sabin.coanda@deuromedia.ro>)
List pgsql-performance
On Mon, Sep 22, 2008 at 2:40 PM, Sabin Coanda
<sabin.coanda@deuromedia.ro> wrote:
> Hi there,
>
> I am still concerned about this problem, because there is a big differences
> between the two cases, and I don't know how to identify the problem. Can
> anybody help me, please ?

Sure, first step, if you can provide the following:

pg version
os and version
output of explain analyze of each query (one good query, one bad)

In the meantime, make sure you've vacuum analyzed your db.

pgsql-performance by date:

Previous
From: "Sabin Coanda"
Date:
Subject: Re: Different execution plan
Next
From: Simon Riggs
Date:
Subject: Re: Intel's X25-M SSD