Re: query tuning - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: query tuning
Date
Msg-id 20030814134826.GD27870@wolff.to
Whole thread Raw
In response to query tuning  (Dave Cramer <Dave@micro-automation.net>)
List pgsql-general
Please don't reply to messages to start a new thread.

On Thu, Aug 14, 2003 at 08:09:23 -0400,
  Dave Cramer <Dave@micro-automation.net> 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?

Have you run vacuum analyze?

Can you supply a copy of the query and explain analyze output?

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: importing db as text files
Next
From: Bruno Wolff III
Date:
Subject: Re: importing db as text files