On Wed, Mar 25, 2009 at 10:28 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Bryan Murphy <bmurphy1976(at)gmail(dot)com> writes:
>> What I did was change seq_page_cost back to 1.0 and then changed
>> random_page_cost to 0.5
> [ squint... ] It makes no physical sense for random_page_cost to be
> less than seq_page_cost. Please set them the same.
> regards, tom lane
Done. Just saw the tip in the docs as well. Both are set to 0.5 now
and I'm still getting the good query plan.
In response to
pgsql-performance by date
|Next:||From: Mark Kirkwood||Date: 2009-03-26 04:28:46|
|Subject: Re: Raid 10 chunksize|
|Previous:||From: Tom Lane||Date: 2009-03-26 03:28:17|
|Subject: Re: Help Me Understand Why I'm Getting a Bad Query Plan |