X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 467AC568C4 for ; Tue, 15 Mar 2005 15:24:04 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 73931-02 for ; Tue, 15 Mar 2005 15:23:51 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id DD1C256912 for ; Tue, 15 Mar 2005 15:22:52 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j2FFMux4006321; Tue, 15 Mar 2005 10:22:56 -0500 (EST) To: "Greg Sabino Mullane" Cc: pgsql-performance@postgresql.org Subject: Re: Changing the random_page_cost default (was: cpu_tuple_cost) In-reply-to: References: Comments: In-reply-to "Greg Sabino Mullane" message dated "Tue, 15 Mar 2005 12:35:19 +0000" Date: Tue, 15 Mar 2005 10:22:56 -0500 Message-ID: <6320.1110900176@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/302 X-Sequence-Number: 11007 "Greg Sabino Mullane" 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. regards, tom lane