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 */
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2007-06-07 13:32:31|
|Subject: Re: Weird 8.2.4 performance |
|Previous:||From: Kurt Overberg||Date: 2007-06-07 11:18:22|
|Subject: Re: Weird 8.2.4 performance|