Re: Wierd context-switching issue on Xeon patch for 7.4.1 - Mailing list pgsql-performance

From Andrew McMillan
Subject Re: Wierd context-switching issue on Xeon patch for 7.4.1
Date
Msg-id 1082877215.8041.20.camel@lamb.mcmillan.net.nz
Whole thread Raw
In response to Re: Wierd context-switching issue on Xeon patch for 7.4.1  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
On Thu, 2004-04-22 at 10:37 -0700, Josh Berkus wrote:
> Tom,
>
> > The tricky
> > part is that a slow adaptation rate means we can't have every backend
> > figuring this out for itself --- the right value would have to be
> > maintained globally, and I'm not sure how to do that without adding a
> > lot of overhead.
>
> This may be a moot point, since you've stated that changing the loop timing
> won't solve the problem, but what about making the test part of make?   I
> don't think too many systems are going to change processor architectures once
> in production, and those that do can be told to re-compile.

Sure they do - PostgreSQL is regularly provided as a pre-compiled
distribution.  I haven't compiled PostgreSQL for years, and we have it
running on dozens of machines, some SMP, some not, but most running
Debian Linux.

Even having a compiler _installed_ on one of our client's database
servers would usually be considered against security procedures, and
would get a black mark when the auditors came through.

Regards,
                    Andrew McMillan
-------------------------------------------------------------------------
Andrew @ Catalyst .Net .NZ  Ltd,  PO Box 11-053,  Manners St,  Wellington
WEB: http://catalyst.net.nz/             PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201       MOB: +64(21)635-694      OFFICE: +64(4)499-2267
                     Planning an election?  Call us!
-------------------------------------------------------------------------


pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Why will vacuum not end?
Next
From: "Shea,Dan [CIS]"
Date:
Subject: Re: Why will vacuum not end?