On 5/14/2013 8:48 AM, ranjita.na...@in.abb.com wrote:
The following bug has been logged on the website:

Bug reference:      8161
Logged by:          Ranjita
Email address:ranjita.na...@in.abb.com
PostgreSQL version: 9.2.4
Operating system:   Windows7
Description:

Why multiple instances of postgres is running in task manager (around 10nos)
if we open the PgAdminIII ?

this is not a bug and should not have been reported as such.

postgres uses a number of processes, the postmaster, the writer, the WAL writer, the checkpointer, the logger, autovacuum launcher, stats collector, plus a process for each user connection. on a typical unix system, with one user connection active, I see 8 processes active at present...

postgres 38425 1 0 01:59 ? 00:00:00 /usr/pgsql-9.2/bin/postmaster -p 5433 -D /data_lightning/pgsql/data
postgres 38427 38425  0 01:59 ?        00:00:00 postgres: logger process
postgres 38429 38425 0 01:59 ? 00:02:18 postgres: checkpointer process
postgres 38430 38425  0 01:59 ?        00:00:13 postgres: writer process
postgres 38431 38425 0 01:59 ? 00:00:03 postgres: wal writer process postgres 38432 38425 0 01:59 ? 00:00:00 postgres: autovacuum launcher process postgres 38433 38425 0 01:59 ? 00:00:09 postgres: stats collector process postgres 39450 38425 85 05:38 ? 01:49:02 postgres: postgres pgbench [local] ALTER TABLE


--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to