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 7EA6D5674C for ; Wed, 16 Mar 2005 15:43:12 +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 20650-08 for ; Wed, 16 Mar 2005 15:43:02 +0000 (GMT) Received: from stark.xeocode.com (stark.xeocode.com [216.58.44.227]) by svr1.postgresql.org (Postfix) with ESMTP id 934FD566BA for ; Wed, 16 Mar 2005 15:43:01 +0000 (GMT) Received: from localhost ([127.0.0.1] helo=stark.xeocode.com) by stark.xeocode.com with smtp (Exim 3.36 #1 (Debian)) id 1DBafc-0000Bn-00; Wed, 16 Mar 2005 10:42:52 -0500 To: "Magnus Hagander" Cc: "Greg Stark" , "David Brown" , "Gregory Stark" Subject: Re: cpu_tuple_cost References: <6BCB9D8A16AC4241919521715F4D8BCE6C7095@algol.sollentuna.se> In-Reply-To: <6BCB9D8A16AC4241919521715F4D8BCE6C7095@algol.sollentuna.se> From: Greg Stark Organization: The Emacs Conspiracy; member since 1992 Date: 16 Mar 2005 10:42:52 -0500 Message-ID: <874qfblhqb.fsf@stark.xeocode.com> Lines: 15 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.3 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.019 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/325 X-Sequence-Number: 11030 "Magnus Hagander" writes: > What about the cache memory on the disk? Even IDE disks have some 8Mb > cache today, which makes a lot of difference for fairly short scans. > Even if it's just read cache. That'll bring the speed of random access > down to a 1=1 relationship with sequential access, assuming all fits in > the cache. 8MB cache is really insignificant compared to the hundreds or thousands of megabytes the OS would be using to cache. You could just add the 8MB to your effective_cache_size (except it's not really 100% effective since it would contain some of the same blocks as the OS cache). -- greg