| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kurt Overberg | 2007-06-07 11:18:22 | Re: Weird 8.2.4 performance |
| Previous Message | Steinar H. Gunderson | 2007-06-07 09:43:04 | Re: Weird 8.2.4 performance |