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 EA2BB9FB20C for ; Tue, 25 Jul 2006 11:57:56 -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 16437-01-6 for ; Tue, 25 Jul 2006 14:57:46 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.170]) by postgresql.org (Postfix) with ESMTP id E291C9FB2C3 for ; Tue, 25 Jul 2006 11:53:30 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id u2so387962uge for ; Tue, 25 Jul 2006 07:53:28 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=ErAjVxwwhaullRRcRaZMUw8oYHIujN2Hl7GtO++t0+IRW31ciEkk5PGz3SzHt+6bY7q3yunBLAMkHN3lxVu4LSJXHPk4A9oWR9lNuXWuCw4pA/Q5fahbLg7v3Ab/D4lyyMb/LSqgairNSlP1tDY0Vg+gxddo0wwyTtAoSO8g7Xk= Received: by 10.78.165.16 with SMTP id n16mr2344480hue; Tue, 25 Jul 2006 07:53:28 -0700 (PDT) Received: by 10.78.32.10 with HTTP; Tue, 25 Jul 2006 07:53:28 -0700 (PDT) Message-ID: Date: Tue, 25 Jul 2006 09:53:28 -0500 From: "Aaron Bono" To: "Szabolcs BALLA" Subject: Re: Out of memory when vacuuming Cc: "Postgresql Admin" In-Reply-To: <44C5D8BB.9070508@confinsystems.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_145759_16807000.1153839208458" References: <44C5D8BB.9070508@confinsystems.com> X-Google-Sender-Auth: c7522b90d7e6f952 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.574 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_30_40, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200607/204 X-Sequence-Number: 22450 ------=_Part_145759_16807000.1153839208458 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline On 7/25/06, Szabolcs BALLA wrote: > > 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 What OS are you using? If you are using Linux, you may want to check the memory limits for the postgres user? Try a "ulimit" on postgres. I had similar problems on my Linux server. ================================================================== Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com ================================================================== ------=_Part_145759_16807000.1153839208458 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On 7/25/06, Szabolcs BALLA <szballa@confinsystems.com> wrote:
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

 
What OS are you using?

If you are using Linux, you may want to check the memory limits for the postgres user?  Try a "ulimit" on postgres.  I had similar problems on my Linux server.

==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
================================================================== ------=_Part_145759_16807000.1153839208458--