Hello,
Is context switching problem resolved in 8.0?
Can I drop in another Xeon?
Thanks,
Jelle
On Wed, 2 Jun 2004, Josh Berkus wrote:
Folks,
I've been testing varying SPINS_PER_DELAY in a client's installation of
PostgreSQL against a copy of a production database, to test varying this
Jellej,
Is context switching problem resolved in 8.0?
Can I drop in another Xeon?
Nope, not solved yet. However, it only affects certain data access patterns.
So don't use it as a reason not to go multi-processor.
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco
Folks,
I've been testing varying SPINS_PER_DELAY in a client's installation of
PostgreSQL against a copy of a production database, to test varying this
statistic as a way of fixing the issue.
It does not seem to work.
I've tested all of the following graduated levels:
100 (the original)