Re: How is random_page_cost=4 ok? - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: How is random_page_cost=4 ok?
Date
Msg-id 48EFCFA0.4050201@agliodbs.com
Whole thread Raw
In response to Re: How is random_page_cost=4 ok?  (Greg Smith <gsmith@gregsmith.com>)
Responses Re: How is random_page_cost=4 ok?
List pgsql-hackers
> I don't think random_page_cost actually corresponds with any real number 
> anymore.  I just treat it as an uncalibrated knob you can turn and 
> benchmark the results at.

And, frankly, not a useful knob.  You get much more useful results out 
of effective_cache_size and cpu_* costs than you get out of messing with 
random_page_cost, unless you're running on SSD or something which would 
justify a lower RPC, or if you're compensating for our poor n-distinct 
estimation for very large tables.

--Josh



pgsql-hackers by date:

Previous
From: Ron Mayer
Date:
Subject: Re: How is random_page_cost=4 ok?
Next
From: Gregory Stark
Date:
Subject: Re: How is random_page_cost=4 ok?