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 5564854D24 for ; Tue, 22 Mar 2005 18:57:44 +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 36982-04 for ; Tue, 22 Mar 2005 18:57:33 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id C21AD566D1 for ; Tue, 22 Mar 2005 18:57:32 +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 j2MIuAlQ010951; Tue, 22 Mar 2005 13:56:10 -0500 (EST) To: Greg Stark Cc: Christopher Browne , pgsql-performance@postgresql.org Subject: Re: What about utility to calculate planner cost constants? In-reply-to: <87hdj3bnc2.fsf@stark.xeocode.com> References: <200503210951.06044.josh@agliodbs.com> <87acowcmut.fsf@stark.xeocode.com> <87hdj3bnc2.fsf@stark.xeocode.com> Comments: In-reply-to Greg Stark message dated "22 Mar 2005 12:30:05 -0500" Date: Tue, 22 Mar 2005 13:56:10 -0500 Message-ID: <10950.1111517770@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/464 X-Sequence-Number: 11169 Greg Stark writes: > Christopher Browne writes: >> Are you certain it's a linear system? > If you just consider the guc parameters that tell postgres how long various > real world operations take (all the *_cost parameters) then it's a linear > system. It has to be. No it doesn't. Think caching effects for instance. We do have cache effects in the cost models, even though they are wrong as per my nearby rant... regards, tom lane