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 42948329E32 for ; Sun, 12 Sep 2004 17:56:07 +0100 (BST) 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 75857-07 for ; Sun, 12 Sep 2004 16:56:04 +0000 (GMT) Received: from fusion.bennyvision.com (fusion.bennyvision.com [216.161.119.28]) by svr1.postgresql.org (Postfix) with SMTP id 26B3A329C67 for ; Sun, 12 Sep 2004 17:56:02 +0100 (BST) Received: (qmail 2821 invoked from network); 12 Sep 2004 16:56:01 -0000 Received: from localhost (HELO webmail.stinkweasel.net) (127.0.0.1) by fusion.bennyvision.com with SMTP; 12 Sep 2004 16:56:01 -0000 Received: from 63.227.74.41 (SquirrelMail authenticated user benny); by webmail.stinkweasel.net with HTTP; Sun, 12 Sep 2004 11:55:39 -0500 (CDT) Message-ID: <58650.63.227.74.41.1095008161.squirrel@63.227.74.41> In-Reply-To: <12799.1094967789@sss.pgh.pa.us> References: <60549.63.227.74.41.1094956933.squirrel@63.227.74.41> <12799.1094967789@sss.pgh.pa.us> Date: Sun, 12 Sep 2004 11:55:39 -0500 (CDT) Subject: Re: Memory exhausted in AllocSetAlloc From: "C. Bensend" To: pgsql-admin@postgresql.org User-Agent: SquirrelMail/1.4.3a X-Mailer: SquirrelMail/1.4.3a MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/109 X-Sequence-Number: 14812 > Maybe it's exceeding a ulimit setting? Bingo. > You might want to watch it with "top" and see what size the process > actually gets to before failing. I'm not sure how accurate the > vacuum_mem throttle is ... It failed immediately upon invocation of vacuumdb. I did find the problem and I feel like an idiot. For some reason the PostgreSQL user's login class didn't get changed from the default on this host. So, it had all kinds of limits set that were too low. I changed that and voila! I'm now running with 64M and my vacuums are much faster. Thanks so much! Benny -- Funniest spam subject: "The mighty cucumber lives again!" -- Received Aug 31, 2004