Lots of postmaster processes

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

Responses

Browse pgsql-admin by date

  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