Re: query tuning - Mailing list pgsql-general

From Fernando Nasser
Subject Re: query tuning
Date
Msg-id 1060969670.2357.4.camel@novo
Whole thread Raw
In response to query tuning  (Dave Cramer <dave@fastcrypt.com>)
List 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


pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Why the duplicate messages to pgsql-general?
Next
From: Tom Lane
Date:
Subject: Re: join of array