pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mark Kirkwood <markir@paradise.net.nz>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Greg Sabino Mullane <greg@turnstep.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Changing the random_page_cost default (was:
Date: Wed, 16 Mar 2005 11:44:06 +1300
Message-ID: <42376536.10500@paradise.net.nz> (raw)
In-Reply-To: <6320.1110900176@sss.pgh.pa.us>
References: <d1376f1e9679b10ba7a9d8cac343ee05@biglumber.com>
	<6320.1110900176@sss.pgh.pa.us>

Tom Lane wrote:
> "Greg Sabino Mullane" <greg@turnstep.com> writes:
> 
>>N.B. My own personal starting default is 2, but I thought 3 was a nice
>>middle ground more likely to reach consensus here. :)
> 
> 
> Your argument seems to be "this produces nice results for me", not
> "I have done experiments to measure the actual value of the parameter
> and it is X".  I *have* done experiments of that sort, which is where
> the default of 4 came from.  I remain of the opinion that reducing
> random_page_cost is a band-aid that compensates (but only partially)
> for problems elsewhere.  We can see that it's not a real fix from
> the not-infrequent report that people have to reduce random_page_cost
> below 1.0 to get results anywhere near local reality.  That doesn't say
> that the parameter value is wrong, it says that the model it's feeding
> into is wrong.
> 

I would like to second that. A while back I performed a number of 
experiments on differing hardware and came to the conclusion that *real* 
random_page_cost was often higher than 4 (like 10-15 for multi-disk raid 
  systems).

However I have frequently adjusted Pg's random_page_cost to be less than 
4 - if it helped queries perform better.

So yes, it looks like the model is the issue - not the value of the 
parameter!

regards

Mark




view thread (5+ messages)  latest in thread

Message-ID: <42376536.10500@paradise.net.nz>
Permalink:  ../42376536.10500@paradise.net.nz/
Also on:    postgresql.org/message-id/42376536.10500@paradise.net.nz

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: markir@paradise.net.nz, tgl@sss.pgh.pa.us, greg@turnstep.com
  Subject: Re: Changing the random_page_cost default (was:
  In-Reply-To: <42376536.10500@paradise.net.nz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox