Re: Wierd context-switching issue on Xeon
jelle <jellej@pacbell.net>
From: jelle <jellej@pacbell.net>
To: pgsql-performance@postgresql.org
Date: 2004-04-20T05:18:21Z
Lists: pgsql-performance
Same problem with dual 1Ghz P3's running Postgres 7.4.2, linux 2.4.x, and 2GB ram, under load, with long transactions (i.e. 1 "cannot serialize" rollback per minute). 200K was the worst observed with vmstat. Finally moved DB to a single xeon box.