X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 3E6769FA5D8 for ; Sun, 4 Jun 2006 04:09:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 80074-09 for ; Sun, 4 Jun 2006 04:09:39 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from stark.xeocode.com (stark.xeocode.com [216.58.44.227]) by postgresql.org (Postfix) with ESMTP id 944E89FA42B for ; Sun, 4 Jun 2006 04:09:39 -0300 (ADT) Received: from localhost ([127.0.0.1] helo=stark.xeocode.com) by stark.xeocode.com with smtp (Exim 3.36 #1 (Debian)) id 1Fmmjr-0002mf-00; Sun, 04 Jun 2006 03:09:31 -0400 To: Greg Stark Cc: Greg Stark , Hannu Krosing , josh@agliodbs.com, David Fetter , Tom Lane , pgsql-hackers@postgresql.org Subject: Re: More thoughts about planner's cost estimates References: <14821.1149104747@sss.pgh.pa.us> <20060602010412.GI10906@fetter.org> <87ac8vfptu.fsf@stark.xeocode.com> <200606021223.35168.josh@agliodbs.com> <87pshre28d.fsf@stark.xeocode.com> <1149362295.3889.29.camel@localhost.localdomain> <874pz1din8.fsf@stark.xeocode.com> <87y7wdbf32.fsf@stark.xeocode.com> In-Reply-To: <87y7wdbf32.fsf@stark.xeocode.com> From: Greg Stark Organization: The Emacs Conspiracy; member since 1992 Date: 04 Jun 2006 03:09:30 -0400 Message-ID: <87slmlbdn9.fsf@stark.xeocode.com> Lines: 10 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.4 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/137 X-Sequence-Number: 84370 Greg Stark writes: > I see improvements up to around 256M blocks or so, but my data is pretty > questionable since I'm busy watching tv in Mythtv in another window. It's on > another drive but it still seems to be making the numbers jump around a bit. Oops, I meant blocks of 256k there. Sorry. -- greg