Re: [HACKERS] many idle processes

2002-07-31 Thread Christopher Kings-Lynne
> Is there a catalog to track those > psql processes - what their functions, who > issues, etc.? > > thanks. > > johnl If you have it enabled in your postgresql.conf, just go: select * from pg_stat_activity; Chris ---(end of broadcast)--- TI

Re: [HACKERS] many idle processes

2002-07-31 Thread Doug McNaught
"John Liu" <[EMAIL PROTECTED]> 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 clo

[HACKERS] many idle processes

2002-07-31 Thread John Liu
I tried to understand what causes too many pgsql idle processes. Can postmaster automatically aged and cleaning up those unused idle process? Is there a catalog to track those psql processes - what their functions, who issues, etc.? thanks. johnl ---(end of broadcast)