Skip site navigation (1) Skip section navigation (2)

Re: Weird 8.2.4 performance

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: Kurt Overberg <kurt(at)hotdogrecords(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Weird 8.2.4 performance
Date: 2007-06-07 09:35:27
Message-ID: 20070607093527.GA22482@uio.no (view raw or flat)
Thread:
Lists: pgsql-performance
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/

In response to

Responses

pgsql-performance by date

Next:From: Steinar H. GundersonDate: 2007-06-07 09:43:04
Subject: Re: Weird 8.2.4 performance
Previous:From: Richard HuxtonDate: 2007-06-07 09:23:19
Subject: Re: Weird 8.2.4 performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group