X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 796D39DC84D for ; Tue, 13 Dec 2005 14:18:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 66987-05 for ; Tue, 13 Dec 2005 14:18:17 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 0D76C9DC819 for ; Tue, 13 Dec 2005 14:18:15 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id jBDII9rm008642; Tue, 13 Dec 2005 13:18:09 -0500 (EST) To: Ameet Kini cc: pgsql-admin@postgresql.org Subject: Re: Lots of postmaster processes In-reply-to: References: Comments: In-reply-to Ameet Kini message dated "Tue, 13 Dec 2005 11:24:26 -0600" Date: Tue, 13 Dec 2005 13:18:09 -0500 Message-ID: <8641.1134497889@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.003 required=5 tests=[AWL=0.003] X-Spam-Score: 0.003 X-Spam-Level: X-Archive-Number: 200512/107 X-Sequence-Number: 19827 Ameet Kini writes: > 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: Lots of postmaster processes can only come from lots of connection requests. You need to look at the behavior of your client code and see why it's doing that. It might also be helpful to use a "ps" command that shows you the per-process state displays rather than the original postmaster arguments. What platform are you on? The only one I know of offhand that does the latter by default is Solaris --- see FAQ_Solaris for how to work around it. regards, tom lane