Re: BUG #5671: ERROR: out of memory - Mailing list pgsql-bugs

From Robert Haas
Subject Re: BUG #5671: ERROR: out of memory
Date
Msg-id AANLkTikVaGtfsgfb4tnraWN8utCK1eR97RJEoEAwpeuS@mail.gmail.com
Whole thread Raw
In response to BUG #5671: ERROR: out of memory  ("Jairo Carrillo" <carsofteu@gmail.com>)
List pgsql-bugs
On Tue, Sep 21, 2010 at 4:54 PM, Jairo Carrillo <carsofteu@gmail.com> wrote:
>
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A05671
> Logged by: =A0 =A0 =A0 =A0 =A0Jairo Carrillo
> Email address: =A0 =A0 =A0carsofteu@gmail.com
> PostgreSQL version: 8.4
> Operating system: =A0 windows server 2003 r2
> Description: =A0 =A0 =A0 =A0ERROR: =A0out of memory
> Details:
>
> INFO: =A0vacuuming "public.localizacion"
>>> ERROR: =A0out of memory
>>> DETAIL: =A0Failed on request of size 1048575996.
>>>
>>> ERROR: =A0out of memory
>>> DETAIL: =A0Failed on request of size 1048575996.

I'm not sure if there's a bug here or not, but it sounds like you're
out of memory. :-)

What is the value of maintenance_work_mem?  How large is the table?
How much memory do you have on your machine?  Exactly which 8.4
release are you running?

--=20
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #5669: server process was terminated by exception 0xC0000005
Next
From: Robert Haas
Date:
Subject: Re: BUG #5669: server process was terminated by exception 0xC0000005