Lots of postmaster processes (fwd)

From: Ameet Kini <akini(at)cs(dot)wisc(dot)edu>
To: pgsql-performance(at)postgresql(dot)org
Subject: Lots of postmaster processes (fwd)
Date: 2005-12-13 17:25:40
Message-ID: Pine.LNX.4.58.0512131124550.1030@karadi.cs.wisc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Resending it here as it may be more relevant here...
Ameet

---------- Forwarded message ----------
Date: Tue, 13 Dec 2005 11:24:26 -0600 (CST)
From: Ameet Kini <akini(at)cs(dot)wisc(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: Lots of postmaster processes

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-performance by date

  From Date Subject
Next Message Scott Marlowe 2005-12-13 17:40:06 Re: Memory Leakage Problem
Previous Message Ключников А.С. 2005-12-13 16:57:59 Re: query from partitions