Skip site navigation (1) Skip section navigation (2)

Re: Weird 8.2.4 performance

From: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
To: pgsql-performance(at)postgresql(dot)org, Kurt Overberg <kurt(at)hotdogrecords(dot)com>
Subject: Re: Weird 8.2.4 performance
Date: 2007-06-07 11:12:52
Message-ID: 4667E834.6010101@paradise.net.nz (view raw or flat)
Thread:
Lists: 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


In response to

pgsql-performance by date

Next:From: Kurt OverbergDate: 2007-06-07 11:18:22
Subject: Re: Weird 8.2.4 performance
Previous:From: Steinar H. GundersonDate: 2007-06-07 09:43:04
Subject: Re: Weird 8.2.4 performance

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