Re: Freeing Connections

Andrew Hill <list(at)fornax(dot)net> writes:
> Normally, 32 connections is heaps for what I need. However, I often get
> connections that seem to be doing nothing. For example:

> [bash]
> \_ postmaster -i -D/var/pgsql/data -N 32 -B 64
> \_ [postmaster]
> \_ /var/pgsql/bin/postgres 202.174.32.67 postgres anb idle
> \_ /var/pgsql/bin/postgres 202.174.32.68 postgres anb idle
> \_ [postmaster]
> \_ /var/pgsql/bin/postgres 203.34.190.137 postgres bmf idle
> \_ [postmaster]
> \_ [postmaster]
> \_ [postmaster]
> \_ [postmaster]
> \_ /var/pgsql/bin/postgres 202.174.32.8 radius bmf idle

Curious. Can you attach to some of the unidentified processes with
a debugger, and get a stack traceback from 'em? Offhand I can't
think of a reason for 7.0 to have any subprocesses that haven't
changed their PS display. It would help to know what they are doing.

regards, tom lane