Re: help tuning queries on large database

From: Mark Lewis <mark(dot)lewis(at)mir3(dot)com>
To: Ron <rjpeace(at)earthlink(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: help tuning queries on large database
Date: 2006-01-11 00:28:06
Message-ID: 1136939286.22590.27.camel@archimedes
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Ron,

A few days back you mentioned:

> Upgrade your kernel to at least 2.6.12
> There's a known issue with earlier versions of the 2.6.x kernel and
> 64b CPUs like the Opteron. See kernel.org for details.
>

I did some searching and couldn't find any obvious mention of this issue
(I gave up after searching through the first few hundred instances of
"64" in the 2.6.12 changelog).

Would you mind being a little more specific about which issue you're
talking about? We're about to deploy some new 16GB RAM Opteron DB
servers and I'd like to check and make sure RH backported whatever the
fix was to their current RHEL4 kernel.

Thanks,
Mark Lewis

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dave Dutcher 2006-01-11 02:06:08 Left Join Performance vs Inner Join Performance
Previous Message Simon Riggs 2006-01-10 23:36:45 Re: NOT LIKE much faster than LIKE?