Date: Thu, 7 Jun 2007 11:35:27 +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: <20070607093527.GA22482@uio.no>
Mail-Followup-To: Kurt Overberg <kurt@hotdogrecords.com>,
	pgsql-performance@postgresql.org
References: <371D1936-E96B-4865-AEEF-C82AC41C2982@hotdogrecords.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <371D1936-E96B-4865-AEEF-C82AC41C2982@hotdogrecords.com>
User-Agent: Mutt/1.5.13 (2006-08-11)

On Wed, Jun 06, 2007 at 07:27:27PM -0400, Kurt Overberg wrote:
> This query runs great on production under 8.0 (27ms), but under 8.2.4  
> (on my mac) I'm seeing times in excess of 50,000ms.  Note that on  
> 8.2.4, if I run the query again, it gets successively faster  
> (50,000ms->6000ms->27ms).  Is this normal?

Your production server probably has all the data in your cache, and your Mac
has not. Furthermore, they seem to be running on different data sets, judging
from your EXPLAIN ANALYZE.

How big did you say these tables were?

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