Re: [PERFORM] Context switching

2006-11-07 Thread Josh Berkus
Carlos, > We've migrated one of our servers from pg 7.4 to 8.1 and from times to > times (4 hours) the server start doing a lot of context switching and all > transactions become very slow. > > The average context switching for this server as vmstat shows is 1 but when > the problem occurs it goes

Re: [PERFORM] Easy read-heavy benchmark kicking around?

2006-11-07 Thread Dimitri Fontaine
Hi, Le lundi 6 novembre 2006 21:47, Brian Hurt a écrit : > So the question is: is there an easy to install and run, read-heavy > benchmark out there that I can wave at them to get them to fix the > problem? I have a second database running on a single SATA drive, so I > can use that as a comparis