Postgres Pro
Downloads
Home   >   mailing lists

Re: Trying to get postgres to use an index - Mailing list pgsql-general

From Troels Arvin
Subject Re: Trying to get postgres to use an index
Date
Msg-id pan.2004.11.06.20.11.56.327301@arvin.dk
Whole thread Raw
In response to Trying to get postgres to use an index  ("Mike Wertheim" <mike.wertheim@linkify.com>)
List pgsql-general
Tree view 
On Sat, 06 Nov 2004 12:00:02 -0800, Mike Wertheim wrote:

> Does anyone have any suggestions on how to make this query run faster?

Does it help if you decrease the value of random_page_cost? - That value
can be changed run-time, from within psql. If you find that a certain,
lower value helps, you can make it permanent in postgresql.conf.

--
Greetings from Troels Arvin, Copenhagen, Denmark

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Mass Import/Generate PKs
Next
From: Mike Cox
Date:
Subject: Re: Postresql RFD version 2.0 Help Wanted.