Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: help needed -- sequential scan problem
- From: Josh Berkus <josh(at)agliodbs(dot)com>
- To: pgsql-performance(at)postgresql(dot)org
- Cc: sarlav kumar <sarlavk(at)yahoo(dot)com>
- Subject: Re: help needed -- sequential scan problem
- Date: Mon, 22 Nov 2004 11:57:38 -0800
- Message-id: <200411221157.38900.josh@agliodbs.com> <text/plain>
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
- Follow-Ups:
- Re: help needed -- sequential scan problem
- From: sarlav kumar
- Re: help needed -- sequential scan problem
- References:
- Re: help needed -- sequential scan problem
- From: sarlav kumar
- Re: help needed -- sequential scan problem
- Prev by Date: Re: help needed -- sequential scan problem
- Next by Date: Re: help needed -- sequential scan problem
- Previous by thread: Re: help needed -- sequential scan problem
- Next by thread: Re: help needed -- sequential scan problem
- Indexes: