Dunno if this has gotten a reply elsewhere, but during a checkpoint the
database can become quite busy. If that happens and performance slows
down, other queries will slow down as well. If you have an app where a
a high rate of incomming requests (like a busy website), existing
backends won't be able to keep up with demand, so incomming connections
will end up spawning more connections to the database.
On Tue, Dec 13, 2005 at 11:25:40AM -0600, Ameet Kini wrote:
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 [EMAIL PROTECTED]
To: pgsql-admin@postgresql.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
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
