Re: Understanding explains

From: Francisco Reyes <lists(at)natserv(dot)com>
To: Rosser Schwarz <rosser(dot)schwarz(at)gmail(dot)com>
Cc: PostgreSQL performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Understanding explains
Date: 2004-10-12 04:59:37
Message-ID: 20041012005749.G98867@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Gabriele Bartolini 2004-10-12 05:26:12 Re: Normal case or bad query plan?
Previous Message Francisco Reyes 2004-10-12 04:56:15 Re: why my query is not using index??