hubert depesz lubaczewski <depesz(at)depesz(dot)com> writes:
> On Fri, Aug 28, 2009 at 12:28:06PM -0400, Tom Lane wrote:
>> Hm, do you have forty or so idle backends hanging around while this
>> happens? The only thing I can think of that might be causing this is
>> shared cache invalidation messages being broadcast to all the other
>> sessions.
> I have about 1000 backends running.
Ouch. You need to update to 8.4 --- the SI messaging stuff will
definitely be hurting you with that many backends. Or consider
using connection pooling or something to cut the number of backends.
regards, tom lane