X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C35823A4051 for ; Wed, 19 Jan 2005 12:24:19 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 77738-02 for ; Wed, 19 Jan 2005 12:24:13 +0000 (GMT) Received: from ankara.ucc.usyd.edu.au (ankara.ucc.usyd.edu.au [129.78.64.57]) by svr1.postgresql.org (Postfix) with ESMTP id F30723A3FF4 for ; Wed, 19 Jan 2005 12:24:14 +0000 (GMT) Received: from ankara.ucc.usyd.edu.au (localhost [127.0.0.1]) by ankara-postfilter.ucc.usyd.edu.au (Postfix) with ESMTP id CB075F7CB4 for ; Wed, 19 Jan 2005 23:24:05 +1100 (EST) Received: from lorica.ucc.usyd.edu.au (lorica.ucc.usyd.edu.au [129.78.64.15]) by ankara.ucc.usyd.edu.au (Postfix) with ESMTP id AC6DBF2320 for ; Wed, 19 Jan 2005 23:24:05 +1100 (EST) Received: from gladius.ucc.usyd.edu.au (gladius.ucc.usyd.edu.au [129.78.64.6]) by lorica.ucc.usyd.edu.au (8.12.10/8.12.10) with ESMTP id j0JCOCxN004927 for ; Wed, 19 Jan 2005 23:24:12 +1100 (EST) Received: (from wwwmail@localhost) by gladius.ucc.usyd.edu.au (8.12.3/8.12.3/Debian-6.6) id j0JCOBDc003642 for pgsql-admin@postgresql.org; Wed, 19 Jan 2005 23:24:11 +1100 Received: from 203-217-26-47.dyn.iinet.net.au (203-217-26-47.dyn.iinet.net.au [203.217.26.47]) by www-mail.usyd.edu.au (IMP) with HTTP for ; Wed, 19 Jan 2005 23:24:11 +1100 Message-ID: <1106137451.41ee516bc6d2d@www-mail.usyd.edu.au> Date: Wed, 19 Jan 2005 23:24:11 +1100 From: jsuen@mail.usyd.edu.au To: pgsql-admin@postgresql.org Subject: postmaster eating up memory MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.4-cvs X-Originating-IP: 203.217.26.47 X-usyd-cess: $Revision: 1.22 $; cleaned=0 defanged=0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.178 tagged_above=0 required=5 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200501/225 X-Sequence-Number: 16084 Hello, I am running AOLserver with postmaster connecting to my PostgreSQL DB backend, and recently ran into a problem restarting my server, to which I used a kill -9 on my AOLserver processes ($ kill -9 nsd) to release the bound IP. The problem now is that, when I start the server up again, it is extremely slow - I run 'top' to see the processes using the most memory, I see a few postmaster processes eating up around 23% of CPU time and 30% of the memory (each). I would imagine this would be what is slowing the server down, but I would like to know if it is safe to kill all the postmaster processes, and probably try to restart the AOLserver after that? Or if a manual restart would solve this issue? Any help would be greatly appreciated, cheers Jon ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.