On Thu, Jan 7, 2010 at 2:48 PM, Carlo Stonebanks
> Doing the updates in smaller chunks resolved these apparent freezes - or,
> more specifically, when the application DID freeze, it didn't do it for more
> than 30 seconds. In all likelyhood, this is the OS and the DB thrashing.
It might well be checkpoints. Have you tried cranking up checkpoint
segments to something like 100 or more and seeing how it behaves then?
In response to
pgsql-performance by date
|Next:||From: Scott Marlowe||Date: 2010-01-08 01:59:39|
|Subject: Re: "large" spam tables and performance: postgres memory parameters|
|Previous:||From: Greg Smith||Date: 2010-01-08 00:38:34|
|Subject: Re: Air-traffic benchmark|