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 11:28:07
Message-ID: 20070607112807.GA23315@uio.no (view raw or flat)
Thread:
Lists: pgsql-performance
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/

In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2007-06-07 13:32:31
Subject: Re: Weird 8.2.4 performance
Previous:From: Kurt OverbergDate: 2007-06-07 11:18:22
Subject: Re: Weird 8.2.4 performance

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