Re: avoiding seqscan? - Mailing list pgsql-performance

From Josh Berkus
Subject Re: avoiding seqscan?
Date
Msg-id 200309281928.52113.josh@agliodbs.com
Whole thread Raw
In response to Re: avoiding seqscan?  (Palle Girgensohn <girgen@pingpong.net>)
List 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

pgsql-performance by date:

Previous
From: Palle Girgensohn
Date:
Subject: Re: avoiding seqscan?
Next
From: Palle Girgensohn
Date:
Subject: Re: avoiding seqscan?