query tuning

From: Dave Cramer <Dave(at)micro-automation(dot)net>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: query tuning
Date: 2003-08-14 12:09:23
Message-ID: 1060862962.1631.102.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
--
Dave Cramer <dave(at)fastcrypt(dot)com>
fastcrypt
--
Dave Cramer <Dave(at)micro-automation(dot)net>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message jason_priebe 2003-08-14 12:46:52 Re: SET TIME ZONE with GMT+X notation
Previous Message Dave Cramer 2003-08-14 12:00:12 query tuning