Vince Vielhaber <vev(at)michvhf(dot)com> writes:
> I was away all day and came back to a logcheck message about running
> out of swap and a process being killed. ps -axww showed a number of
> these:
> /usr/local/pgsql/bin/postgres nobody 127.0.0.1 twig idle
Those aren't deadlocked, they're just waiting for their clients to
do something. You might have a problem on the client side ...
regards, tom lane