We did profile the sql. The stand alone statements generally execute in less than 30 ms. The clients (not browsers) send very short delimited text messages to the server. The server parses them and inserts a record for each message and only returns an HTTP 200, 400 to the client.
I guess my confusion is why such a short message would cause postmaster to use so much CPU. Several messages may arrive simultaneously and that many postmasters get kicked off.
We are currently installing the pgpool tool but I was wondering if there were any other things I could try.
From: ries van Twisk [mailto:firstname.lastname@example.org]
Sent: Thursday, September 18, 2008 11:46 AM
To: Wright, George
Subject: Re: [NOVICE] cpu utilization question
On Sep 18, 2008, at 10:09 AM, Wright, George wrote: