Thread: BUG #5671: ERROR: out of memory

BUG #5671: ERROR: out of memory

From
"Jairo Carrillo"
Date:
The following bug has been logged online:

Bug reference:      5671
Logged by:          Jairo Carrillo
Email address:      carsofteu@gmail.com
PostgreSQL version: 8.4
Operating system:   windows server 2003 r2
Description:        ERROR:  out of memory
Details:

INFO:  vacuuming "public.localizacion"
>> ERROR:  out of memory
>> DETAIL:  Failed on request of size 1048575996.
>>
>> ERROR:  out of memory
>> DETAIL:  Failed on request of size 1048575996.

Re: BUG #5671: ERROR: out of memory

From
Robert Haas
Date:
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