From: | Ameet Kini <akini(at)cs(dot)wisc(dot)edu> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Lots of postmaster processes |
Date: | 2005-12-13 17:24:26 |
Message-ID: | Pine.LNX.4.58.0512131121450.1030@karadi.cs.wisc.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
In our installation of the postgres 7.4.7, we are seeing a lot of the
following postmaster processes (around 50) being spawned by the initial
postmaster process once in a while:
postgres 3977 1 1 Nov03 ? 15:11:38
/s/postgresql-7.4.7/bin/postmaster -D /scratch.1/postgres/condor-db-7.4.7
......
postgres 31985 3977 0 10:08 ? 00:00:00
/s/postgresql-7.4.7/bin/postmaster -D /scratch.1/postgres/condor-db-7.4.7
postgres 31986 3977 0 10:08 ? 00:00:00
/s/postgresql-7.4.7/bin/postmaster -D /scratch.1/postgres/condor-db-7.4.7
postgres 31987 3977 0 10:08 ? 00:00:00
/s/postgresql-7.4.7/bin/postmaster -D /scratch.1/postgres/condor-db-7.4.7
postgres 31988 3977 0 10:08 ? 00:00:00
/s/postgresql-7.4.7/bin/postmaster -D /scratch.1/postgres/condor-db-7.4.7
......
At the same time when these processes being spawned, sometimes there is
also the checkpoint subprocess. I am not sure if that is related. The
document doesn't provide any information. The other activity going on at
the same time is a 'COPY' statement from a client application.
These extra processes put a considerable load on the machine and cause it
to hang up.
Thanks,
Ameet
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Hoover | 2005-12-13 17:25:47 | PG 8.1.1 rhel-as-4 rpms missing |
Previous Message | Matthew T. O'Connor | 2005-12-13 13:22:30 | Re: pg_autovacuum log size in postgres v8.0 |