Date: Thu, 7 Jun 2007 13:28:07 +0200
From: "Steinar H. Gunderson" <sgunderson@bigfoot.com>
To: Kurt Overberg <kurt@hotdogrecords.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Weird 8.2.4 performance
Message-ID: <20070607112807.GA23315@uio.no>
Mail-Followup-To: Kurt Overberg <kurt@hotdogrecords.com>,
	pgsql-performance@postgresql.org
References: <371D1936-E96B-4865-AEEF-C82AC41C2982@hotdogrecords.com>
	<46674AEF.6040803@paradise.net.nz> <4667CE87.30101@archonet.com>
	<C040B179-DBCF-441F-9677-E03AE663CEF9@hotdogrecords.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <C040B179-DBCF-441F-9677-E03AE663CEF9@hotdogrecords.com>
User-Agent: Mutt/1.5.13 (2006-08-11)

On Thu, Jun 07, 2007 at 07:18:22AM -0400, Kurt Overberg wrote:
> - My production environment is running RedHat 2.6.9.ELsmp on a server  
> with 16GB of memory

Seriously, this (the RAM amount) _is_ all the difference. (You don't say how
much RAM is in your Mac, but something tells me it's not 16GB.) If you install
8.2.4 on your server, there's no reason why the query you pasted shouldn't be
at least as fast as on 8.0.

> Is there a primer somewhere on how to read EXPLAIN output?

Yes, the documentation contains one.

/* Steinar */
-- 
Homepage: http://www.sesse.net/