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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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