X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 5EBC29FB224 for ; Tue, 25 Jul 2006 06:03:16 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 19280-02-4 for ; Tue, 25 Jul 2006 09:03:10 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 8573F9FB2C3 for ; Tue, 25 Jul 2006 05:39:28 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from galagonx.fixdial.interware.hu (galagonx.fixdial.interware.hu [195.70.45.31]) by svr4.postgresql.org (Postfix) with ESMTP id 605B65AF032 for ; Tue, 25 Jul 2006 08:39:26 +0000 (GMT) Received: from szballa-xp.intra ([172.20.80.67]) by galagonx.fixdial.interware.hu with esmtp (Exim 3.36 #1 (Debian)) id 1G5IRk-0002as-00 for ; Tue, 25 Jul 2006 10:39:20 +0200 Message-ID: <44C5D8BB.9070508@confinsystems.com> Date: Tue, 25 Jul 2006 10:39:23 +0200 From: Szabolcs BALLA User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) MIME-Version: 1.0 To: Postgresql Admin Subject: Out of memory when vacuuming X-Enigmail-Version: 0.94.0.0 Content-Type: text/plain; charset=ISO-8859-2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200607/197 X-Sequence-Number: 22443 Hi, I upgraded my server from 7.4.7 to 8.1.4 and when I want to run a vacuum analyze verbose I've got this error message: INFO: vacuuming "public.lgevents" ERROR: out of memory DETAIL: Failed on request of size 262143996. My settings: shared_buffers = 300000 temp_buffers = 256000 work_mem = 256000 maintenance_work_mem = 256000 max_fsm_pages = 250000 effective_cache_size = 614400 My server has 16Gbyte memory, and kernel.shmmax = 4294967295 Do you have any idea why I got this error message Thanks, Szabek