Re: help needed -- sequential scan problem - Mailing list pgsql-performance

From Josh Berkus
Subject Re: help needed -- sequential scan problem
Date
Msg-id 200411221157.38900.josh@agliodbs.com
Whole thread Raw
In response to Re: help needed -- sequential scan problem  (sarlav kumar <sarlavk@yahoo.com>)
Responses Re: help needed -- sequential scan problem
List pgsql-performance
Sarlav,

> I am sorry, I am not aware of what random_page_cost is, as I am new to
> Postgres. What does it signify and how do I reduce random_page_cost?

It's a parameter in your postgresql.conf file.    After you test it, you will
want to change it there and reload the server (pg_ctl reload).

However, you can test it on an individual connection:
SET random_page_cost=2.5
(the default is 4.0)

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: sarlav kumar
Date:
Subject: Re: help needed -- sequential scan problem
Next
From: sarlav kumar
Date:
Subject: Re: help needed -- sequential scan problem