Re: query tuning

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Dave Cramer <Dave(at)micro-automation(dot)net>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: query tuning
Date: 2003-08-14 13:48:26
Message-ID: 20030814134826.GD27870@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)micro-automation(dot)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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mel Roman 2003-08-14 13:50:23 Re: PostGreSQL - Accessing It
Previous Message Bruno Wolff III 2003-08-14 13:45:20 Re: importing db as text files