Why i see several postgres server processes sometimes ?

From: Georgi Ivanov <georgi(dot)r(dot)ivanov(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Why i see several postgres server processes sometimes ?
Date: 2010-10-06 14:44:29
Message-ID: AANLkTimh_tuXQ62PymvNd95vetQzmWaRMO7Q7QvRjB5M@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I wander why i see several postgres server processes with different PIDs
I don't mean those normal query processes. I see several of these:
/usr/lib/postgresql/8.4/bin/postgres -D /database/postgresql/8.4/main -c
config_file=/etc/postgresql/8.4/main/postgresql.conf

With different pids. Is this normal ?

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+
COMMAND

27662 postgres 20 0 1623m 14m 10m R 5 0.3 0:00.14 postgres: wmg
wmg 172.18.9.21(43725)
idle

15489 postgres 20 0 1610m 33m 33m S 3 0.7 76:51.46
/usr/lib/postgresql/8.4/bin/postgres -D /database/postgresql/8.4/main -c
config_file=/etc/postgresql/8.4/main/postgresql.conf

27714 postgres 20 0 1613m 7720 5228 S 1 0.2 0:00.03 postgres: wmg
wmg 172.18.9.12(42434)
idle

27730 postgres 20 0 1611m 2336 1228 R 1 0.0 0:00.02
/usr/lib/postgresql/8.4/bin/postgres -D /database/postgresql/8.4/main -c
config_file=/etc/postgresql/8.4/main/postgresql.conf

27731 postgres 20 0 1610m 1572 1044 R 1 0.0 0:00.02
/usr/lib/postgresql/8.4/bin/postgres -D /database/postgresql/8.4/main -c
config_file=/etc/postgresql/8.4/main/postgresql.conf

15494 postgres 20 0 1611m 1.5g 1.5g S 0 30.6 6:10.54 postgres:
writer
process

27711 postgres 20 0 1613m 7752 5248 S 0 0.2 0:00.01 postgres: wmg
wmg 172.18.9.13(53169)
idle

27729 postgres 20 0 1610m 1572 1044 R 0 0.0 0:00.01
/usr/lib/postgresql/8.4/bin/postgres -D /database/postgresql/8.4/main -c
config_file=/etc/postgresql/8.4/main/postgresql.conf

15495 postgres 20 0 1611m 1020 652 S 0 0.0 0:23.09 postgres: wal
writer
process

15496 postgres 20 0 1612m 1648 564 S 0 0.0 0:24.77 postgres:
autovacuum launcher
process

15497 postgres 20 0 73524 1308 296 S 0 0.0 18:29.63 postgres: stats
collector
process

17480 postgres 20 0 37052 940 936 S 0 0.0 0:00.01 su
postgres

17481 postgres 20 0 19384 1236 1232 S 0 0.0 0:00.01
bash

17510 postgres 20 0 67696 2400 1992 S 0 0.0 0:00.12
/usr/lib/postgresql/8.4/bin/psql
wmg

17537 postgres 20 0 1617m 26m 21m S 0 0.5 0:00.12 postgres:
postgres wmg [local]
idle

27722 postgres 20 0 1614m 10m 7372 R 0 0.2 0:00.00 postgres: wmg
wmg 172.18.9.13(53195)
idle

27724 postgres 20 0 1613m 7700 5208 R 0 0.2 0:00.00 postgres: wmg
wmg 172.18.9.12(42452)
PARSE

27727 postgres 20 0 1613m 4324 2336 R 0 0.1 0:00.00 postgres: wmg
wmg 172.18.9.13(53204)
startup

27732 postgres 20 0 1610m 424 0 R 0 0.0 0:00.00
/usr/lib/postgresql/8.4/bin/postgres -D /database/postgresql/8.4/main -c
config_file=/etc/postgresql/8.4/main/postgresql.conf

27733 postgres 20 0 1610m 424 0 R 0 0.0 0:00.00
/usr/lib/postgresql/8.4/bin/postgres -D /database/postgresql/8.4/main -c
config_file=/etc/postgresql/8.4/main/postgresql.conf

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2010-10-06 14:49:30 Re: PG website testing
Previous Message Josh Kupershmidt 2010-10-06 14:05:39 Re: How do I write this query? Distinct, Group By, Order By?