Skip site navigation (1) Skip section navigation (2)

Re: avoiding seqscan?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Palle Girgensohn <girgen(at)pingpong(dot)net>,pgsql-performance(at)postgresql(dot)org
Subject: Re: avoiding seqscan?
Date: 2003-09-29 02:28:52
Message-ID: (view raw or whole thread)
Lists: pgsql-performance

> Indeed, setting random_page_cost does the trick. Thanks!
> It seems to make sense to set random_page_cost to this value. Are there any
> drawbacks?

Only if your server was heavily multi-tasking, and as a result had little 
RAM+CPU available.  Then you'd want to raise the value again.

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

pgsql-performance by date

Next:From: Palle GirgensohnDate: 2003-09-29 13:25:36
Subject: Re: avoiding seqscan?
Previous:From: Palle GirgensohnDate: 2003-09-28 22:56:54
Subject: Re: avoiding seqscan?

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group