X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 9D79BD1BA48 for ; Mon, 23 Feb 2004 03:24:34 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 36285-04 for ; Sun, 22 Feb 2004 23:24:32 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 9B1A5D1B9BD for ; Sun, 22 Feb 2004 23:24:27 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i1N3OTBW020383; Sun, 22 Feb 2004 22:24:29 -0500 (EST) To: Sean Shanny Cc: pgsql-performance@postgresql.org Subject: Re: General performance questions about postgres on Apple In-reply-to: <40396A16.9040301@earthlink.net> References: <403682D6.60807@earthlink.net> <19368.1077492611@sss.pgh.pa.us> <40396A16.9040301@earthlink.net> Comments: In-reply-to Sean Shanny message dated "Sun, 22 Feb 2004 21:48:54 -0500" Date: Sun, 22 Feb 2004 22:24:29 -0500 Message-ID: <20382.1077506669@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/259 X-Sequence-Number: 5783 Sean Shanny 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