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 13:28:07 +0200
Message-ID: <20070607112807.GA23315@uio.no> (raw)
In-Reply-To: <C040B179-DBCF-441F-9677-E03AE663CEF9@hotdogrecords.com>
References: <371D1936-E96B-4865-AEEF-C82AC41C2982@hotdogrecords.com>
<46674AEF.6040803@paradise.net.nz>
<4667CE87.30101@archonet.com>
<C040B179-DBCF-441F-9677-E03AE663CEF9@hotdogrecords.com>
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/
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: <20070607112807.GA23315@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