Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id DACCF9FB43C for ; Thu, 7 Jun 2007 08:13:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 45338-10 for ; Thu, 7 Jun 2007 08:13:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from smtp4.clear.net.nz (smtp4.clear.net.nz [203.97.37.64]) by postgresql.org (Postfix) with ESMTP id 7A69B9FB55A for ; Thu, 7 Jun 2007 08:13:09 -0300 (ADT) Received: from [192.168.1.11] (121-72-72-14.dsl.telstraclear.net [121.72.72.14]) by smtp4.clear.net.nz (CLEAR Net Mail) with ESMTP id <0JJ900GQRJ5T1010@smtp4.clear.net.nz> for pgsql-performance@postgresql.org; Thu, 07 Jun 2007 23:13:06 +1200 (NZST) Date: Thu, 07 Jun 2007 23:12:52 +1200 From: Mark Kirkwood Subject: Re: Weird 8.2.4 performance In-reply-to: <20070607094304.GA22543@uio.no> To: pgsql-performance@postgresql.org, Kurt Overberg Message-id: <4667E834.6010101@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7bit References: <371D1936-E96B-4865-AEEF-C82AC41C2982@hotdogrecords.com> <20070607093527.GA22482@uio.no> <20070607094304.GA22543@uio.no> User-Agent: Thunderbird 1.5.0.10 (X11/20070313) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/124 X-Sequence-Number: 25157 Steinar H. Gunderson wrote: > On Thu, Jun 07, 2007 at 11:35:27AM +0200, Steinar H. Gunderson wrote: > > 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. > That's a good point, however its not immediately obvious that the production server is *not* running MacOSX Tiger (or has any more memory)... Kurt can you post the relevant specs for the the 8.0 and 8.2 boxes? Cheers Mark