Postgres Pro
Downloads
Home   >   mailing lists

query tuning - Mailing list pgsql-general

From Dave Cramer
Subject query tuning
Date
Msg-id 1060862962.1631.102.camel@localhost.localdomain
Whole thread Raw
In response to Re: importing db as text files  (expect <expect@ihubbell.com>)
Responses Re: query tuning  (Bruno Wolff III <bruno@wolff.to>)
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
--
Dave Cramer <Dave@micro-automation.net>

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: tsearch2 in 7.4beta1 compile problem
Next
From:
Date:
Subject: Re: SET TIME ZONE with GMT+X notation