Re: help needed -- sequential scan problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux