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

From Josh Berkus
Subject Re: Wierd context-switching issue on Xeon
Date
Msg-id 200404291121.51247.josh@agliodbs.com
Whole thread Raw
In response to Re: Wierd context-switching issue on Xeon  (Robert Creager <Robert_Creager@LogicalChaos.org>)
Responses Re: Wierd context-switching issue on Xeon
List pgsql-performance
Rob,

> I would like to see the same, as I have a system that exhibits the same
behavior
> on a production db that's running 7.4.1.

If you checked the thread follow-ups,  you'd see that *decreasing*
spins_per_delay was not beneficial.   Instead, try increasing them, one step
at a time:

(take baseline measurement at 100)
250
500
1000
1500
2000
3000
5000

... until you find an optimal level.   Then report the results to us!

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


pgsql-performance by date:

Previous
From: "Gary Doades"
Date:
Subject: Re: planner/optimizer question
Next
From: Rod Taylor
Date:
Subject: Re: planner/optimizer question