From: Tom Lane <tgl@sss.pgh.pa.us>
To: Sean Shanny <shannyconsulting@earthlink.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: General performance questions about postgres on Apple
Date: Sun, 22 Feb 2004 22:24:29 -0500
Message-ID: <20382.1077506669@sss.pgh.pa.us> (raw)
In-Reply-To: <40396A16.9040301@earthlink.net>
References: <Pine.LNX.4.33.0402201405160.11556-100000@css120.ihs.com>
<403682D6.60807@earthlink.net>
<19368.1077492611@sss.pgh.pa.us>
<40396A16.9040301@earthlink.net>
Sean Shanny <shannyconsulting@earthlink.net> writes:
> We have the following setting for random page cost:
> random_page_cost = 1 # units are one sequential page fetch cost
> Any suggestions on what to bump it up to?
Well, the default setting is 4 ... what measurements prompted you to
reduce it to 1? The particular example you showed suggested that the
true value on your setup might be 10 or more.
Now I would definitely not suggest that you settle on any particular
value based on only one test case. You need to try to determine an
appropriate average value, bearing in mind that there's likely to be
lots of noise in any particular measurement.
But in general, setting random_page_cost to 1 is only reasonable when
you are dealing with a fully-cached-in-RAM database, which yours isn't.
regards, tom lane
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: tgl@sss.pgh.pa.us, shannyconsulting@earthlink.net
Subject: Re: General performance questions about postgres on Apple
In-Reply-To: <20382.1077506669@sss.pgh.pa.us>
* 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