Postgres Pro
Downloads
Home   >   mailing lists

query tuning - Mailing list pgsql-general

From Dave Cramer
Subject query tuning
Date
Msg-id 1060862412.1721.99.camel@localhost.localdomain
Whole thread Raw
In response to Re: importing db as text files  (expect <expect@ihubbell.com>)
Responses Re: query tuning  (Franco Bruno Borghesi <franco@akyasociados.com.ar>)
Re: query tuning  (Fernando Nasser <fnasser@redhat.com>)
Re: query tuning  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
Tree view 
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@fastcrypt.com>
fastcrypt

pgsql-general by date:

Previous
From: "Nagy Karoly"
Date:
Subject: Manage PostgreSQL Connections
Next
From: Doug McNaught
Date:
Subject: Re: PostGreSQL - Accessing It