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 680BF3A4E55 for ; Sun, 9 Jan 2005 14:35:49 +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 38651-09 for ; Sun, 9 Jan 2005 14:35:41 +0000 (GMT) Received: from laptop.kieser.net (kieser2.demon.co.uk [80.176.229.121]) by svr1.postgresql.org (Postfix) with ESMTP id 74B9C3A4A9A for ; Sun, 9 Jan 2005 14:35:42 +0000 (GMT) Received: from [127.0.0.1] (laptop.kieser2.demon.co.uk [127.0.0.1]) by laptop.kieser.net (Postfix) with ESMTP id CFBE918341 for ; Sun, 9 Jan 2005 14:36:09 +0000 (GMT) Message-ID: <41E1405A.1060603@kieser.net> Date: Sun, 09 Jan 2005 14:31:54 +0000 From: Bradley Kieser User-Agent: Mozilla Thunderbird 0.8 (X11/20040913) X-Accept-Language: en, en-us MIME-Version: 1.0 To: PgSQL ADMIN Subject: Postgres kills machine Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.331 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200501/52 X-Sequence-Number: 15911 Periodically we have queries (can't log in to see which ones) that kill our machine by consuming huge amounts of resource. I thought that I had fixed this by writing a cron job that vacuums all the databases every night, but today our machine froze again. We run PG on Linux, for the machine in question is it Mandrake 10.0. The errors in the syslog are all to do with VM, so I assume that we are running out of RAM. There is 1.5GB of RAM in the box which should be more than enough for the databases that we run. I know that I can set process limits in the limits.conf file, but can anyone suggest sensible values to put in there to limit the max memory to 200MB per pg process? I have read that limits.conf only works if PG is linked using PAM and someone in a thread said that PG doesn't use PAM. Can someone please advise me on this? Thanks, Brad