Re: [PERFORM] Occasional Slow Commit

2008-10-29 Thread David Rees
On Wed, Oct 29, 2008 at 6:26 AM, Greg Smith <[EMAIL PROTECTED]> wrote: > The CentOS 4.7 kernel will happily buffer about 1.6GB of writes with that > much RAM, and the whole thing can get slammed onto disk during the final > fsync portion of the checkpoint. What you should do first is confirm > whe

Re: [PERFORM] Occasional Slow Commit

2008-10-29 Thread Greg Smith
On Mon, 27 Oct 2008, David Rees wrote: Software: CentOS 4.7, PostgreSQL 8.3.4, Slony-I 1.2.15 (the database in question is replicated using slony) Hardware: 2x Xeon 5130, 4GB RAM, 6-disk RAID10 15k RPM, BBU on the controller The CentOS 4.7 kernel will happily buffer about 1.6GB of writes with