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: 200309281928.52113.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
Palle,

> 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-2014 The PostgreSQL Global Development Group