query tuning

From: Dave Cramer <dave(at)fastcrypt(dot)com>
To:
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: query tuning
Date: 2003-08-14 12:00:12
Message-ID: 1060862412.1721.99.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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Cramer 2003-08-14 12:09:23 query tuning
Previous Message Nabil Sayegh 2003-08-14 10:21:57 Re: drop/add fk in transaction