Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 37CF49FB553 for ; Thu, 7 Jun 2007 06:43:13 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 39158-04 for ; Thu, 7 Jun 2007 06:43:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from cassarossa.samfundet.no (cassarossa.samfundet.no [129.241.93.19]) by postgresql.org (Postfix) with ESMTP id B83389FB501 for ; Thu, 7 Jun 2007 06:43:06 -0300 (ADT) Received: from trofast.ipv6.sesse.net ([2001:700:300:1803:20e:cff:fe36:a766] helo=trofast.sesse.net) by cassarossa.samfundet.no with esmtp (Exim 4.50) id 1HwEWG-0007bz-Rr; Thu, 07 Jun 2007 11:43:05 +0200 Received: from sesse by trofast.sesse.net with local (Exim 3.36 #1 (Debian)) id 1HwEWG-0005s9-00; Thu, 07 Jun 2007 11:43:04 +0200 Date: Thu, 7 Jun 2007 11:43:04 +0200 From: "Steinar H. Gunderson" To: pgsql-performance@postgresql.org Cc: Kurt Overberg Subject: Re: Weird 8.2.4 performance Message-ID: <20070607094304.GA22543@uio.no> Mail-Followup-To: pgsql-performance@postgresql.org, Kurt Overberg References: <371D1936-E96B-4865-AEEF-C82AC41C2982@hotdogrecords.com> <20070607093527.GA22482@uio.no> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <20070607093527.GA22482@uio.no> X-Operating-System: Linux 2.6.20.4 on a x86_64 X-Message-Flag: Outlook? --> http://www.mozilla.org/products/thunderbird/ User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/123 X-Sequence-Number: 25156 On Thu, Jun 07, 2007 at 11:35:27AM +0200, Steinar H. Gunderson wrote: > How big did you say these tables were? Sorry, you already said that -- 650k rows for one of them. If that table doesn't fit in the cache on your Mac, you pretty much lose. From the EXPLAIN output, it looks like it fits very nicely in cache on your server. Thus, I don't think the difference is between 8.0 and 8.2, but rather your production server and your test machine. /* Steinar */ -- Homepage: http://www.sesse.net/