Re: Weird 8.2.4 performance - Mailing list pgsql-performance

From Mark Kirkwood
Subject Re: Weird 8.2.4 performance
Date
Msg-id 4667E834.6010101@paradise.net.nz
Whole thread Raw
In response to Re: Weird 8.2.4 performance  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
List pgsql-performance
Steinar H. Gunderson wrote:
> On Thu, Jun 07, 2007 at 11:35:27AM +0200, Steinar H. Gunderson wrote:
>
> If that table
> doesn't fit in the cache on your Mac, you pretty much lose. From the EXPLAIN
> output, it looks like it fits very nicely in cache on your server. Thus, I
> don't think the difference is between 8.0 and 8.2, but rather your production
> server and your test machine.
>

That's a good point, however its not immediately obvious that the
production server is *not* running MacOSX Tiger (or has any more
memory)... Kurt can you post the relevant specs for the the 8.0 and 8.2
boxes?

Cheers

Mark


pgsql-performance by date:

Previous
From: "Steinar H. Gunderson"
Date:
Subject: Re: Weird 8.2.4 performance
Next
From: Kurt Overberg
Date:
Subject: Re: Weird 8.2.4 performance