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
Date: Thu, 7 Jun 2007 11:35:27 +0200
Message-ID: <20070607093527.GA22482@uio.no> (raw)
In-Reply-To: <371D1936-E96B-4865-AEEF-C82AC41C2982@hotdogrecords.com>
References: <371D1936-E96B-4865-AEEF-C82AC41C2982@hotdogrecords.com>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sgunderson@bigfoot.com, kurt@hotdogrecords.com
Subject: Re: Weird 8.2.4 performance
In-Reply-To: <20070607093527.GA22482@uio.no>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox