Re: query tuning

From: Fernando Nasser <fnasser(at)redhat(dot)com>
To: dave(at)fastcrypt(dot)com
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: query tuning
Date: 2003-08-15 17:47:50
Message-ID: 1060969670.2357.4.camel@novo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

SET enable_seqscan TO FALSE;
<your query>
SET enable_seqscan TO TRUE;

Is this what you where looking for?

Regards,
Fernando

On Thu, 2003-08-14 at 08:00, Dave Cramer wrote:
> I have a query which definitely runs faster when sequential scans are
> turned off. Which parameters do I tune? and which way?
>
> After quickly perusing the docs, and google, I think it is the
> random_page_cost?
>
> Any help would be appreciated.
>
> Dave

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Pflug 2003-08-15 17:48:49 Re: [GENERAL] 7.4Beta
Previous Message Joe Conway 2003-08-15 17:41:15 Re: join of array