Craig James <craig_james@emolecules.com> wrote:
>> Well, the "if it ain't broke, don't fix it" rule might come into
>> play here.
>
> I should have given one more detail here: We've been the victim
> of persistent "CPU spikes" that were discussed extensively in
> postgres-performance. Tom suggested upgrading to 8.4.4, but that
> can't happen for a couple more months (we're working on it).
>
>
http://archives.postgresql.org/pgsql-performance/2010-04/msg00071.php
Ah, I hadn't connected that thread with this. After rereading that
thread with the information from this thread in mind, I think what
you describe on the other thread could well be the "thundering herd"
problem. Some form of connection pooling could well help.
BTW, I hope you've updated to the latest 8.3.x by now. If not, you
should expedite that.
-Kevin