Re: Different execution plan

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Different execution plan
Date: 2008-09-22 21:19:07
Message-ID: dcc563d10809221419k25e5a75i1e95984ef382f7f2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Sep 22, 2008 at 2:40 PM, Sabin Coanda
<sabin(dot)coanda(at)deuromedia(dot)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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Simon Riggs 2008-09-23 04:48:43 Re: Intel's X25-M SSD
Previous Message Sabin Coanda 2008-09-22 20:40:15 Re: Different execution plan