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: (view raw, whole thread or download thread mbox)
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

How big did you say these tables were?

/* Steinar */

In response to


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-2017 The PostgreSQL Global Development Group