Re: many idle processes

"John Liu" <johnl(at)synthesys(dot)com> writes:

> I tried to understand what causes
> too many pgsql idle processes. Can
> postmaster automatically aged and
> cleaning up those unused idle process?

Those processes are attached to open client connections. If you don't
like them, change your client to close connections when it's not using
them, but your app will be slower since creating a new connection
(and backend process) takes some time.

> Is there a catalog to track those
> psql processes - what their functions, who
> issues, etc.?

There is one backend process per open client connection, plus the
postmaster, which handles creating new connections.

-Doug