Re: Understanding explains - Mailing list pgsql-performance

From Francisco Reyes
Subject Re: Understanding explains
Date
Msg-id 20041012005749.G98867@zoraida.natserv.net
Whole thread Raw
In response to Re: Understanding explains  (Rosser Schwarz <rosser.schwarz@gmail.com>)
List pgsql-performance
On Mon, 11 Oct 2004, Rosser Schwarz wrote:

> In general, it's best to let the planner make the appropriate choice
> without any artificial constraints.

As someone suggested ran with Explain analyze.
With seqscan_off was better.
Ran a vacuum analyze this afternoon so the stats were up to date.
Although I will leave the setting as it's default for most of everything I
do, it seems that for some reason in this case it mases sense to turn it
off.

pgsql-performance by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: why my query is not using index??
Next
From: Gabriele Bartolini
Date:
Subject: Re: Normal case or bad query plan?