On Wed, Jun 07, 2006 at 07:07:55PM -0400, Mark Woodward wrote: > I guess what I am saying is that PostgreSQL isn't "smooth," between > checkpoints and vacuum, it is near impossible to make a product that > performs consistently under high load.
Have you tuned the bgwriter and all the vacuum_cost stuff? I've get to find a case where I couldn't smooth out the IO load so that it wasn't an issue. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
