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

From Josh Berkus
Subject Re: Wierd context-switching issue on Xeon patch for 7.4.1
Date
Msg-id 200404221037.10097.josh@agliodbs.com
Whole thread Raw
In response to Re: Wierd context-switching issue on Xeon patch for 7.4.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Wierd context-switching issue on Xeon patch for 7.4.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Wierd context-switching issue on Xeon patch for 7.4.1  (Andrew McMillan <andrew@catalyst.net.nz>)
List pgsql-performance
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.

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Pallav Kalva
Date:
Subject: Setting Shared Buffers , Effective Cache, Sort Mem Parameters
Next
From: Tom Lane
Date:
Subject: Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks