Vacuum - Out of memory

From: "Tomeh, Husam" <htomeh(at)firstam(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Vacuum - Out of memory
Date: 2006-01-30 22:31:41
Message-ID: CB0FB369FF86E248A884BCC002562BCB010C0A42@pisgsna01sxch01.ana.firstamdata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I'm getting out of memory error when I try to vacuum a table (any table
in fact).

=# vacuum analyze code;
ERROR: out of memory
DETAIL: Failed on request of size 1073741820.

I'm running Postgres 8.1.1 on RedHat 2.6 kernel (HP server). I never had
this error before and I ran vacuum every night regularly.
When I ran the vacuum on a different server with the same identical
(cloned) database and settings, vacuum works fine with no error.

My maintenance work area never been changed. It's set to 1GB.
(maintenance_work_mem = 1048576).
Physical memory: 32 GB. Top utilities shows:

Mem: 32752736k total, 14948340k used, 17804396k free, 122732k buffers
Swap: 2144668k total, 165140k used, 1979528k free, 14265048k cached

I bounced the database and still getting the same error. I could try
decreasing the maintenance_work_mem but I have plenty of memory and I
need it to process my nightly jobs faster. Any idea why I'm getting
out-of-memory error? Thanks,
__

Husam

**********************************************************************
This message contains confidential information intended only for the use of the addressee(s) named above and may contain information that is legally privileged. If you are not the addressee, or the person responsible for delivering it to the addressee, you are hereby notified that reading, disseminating, distributing or copying this message is strictly prohibited. If you have received this message by mistake, please immediately notify us by replying to the message and delete the original message immediately thereafter.

Thank you.

FADLD Tag
**********************************************************************

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Frost 2006-01-30 22:41:43 Re: pg_stat_user_indexes view clarification
Previous Message Tom Lane 2006-01-30 22:24:47 Re: pg_stat_user_indexes view clarification