Postgres Pro
Downloads
Home   >   mailing lists

Re: vacuumdb: ERROR: invalid memory alloc request size 4294967292 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: vacuumdb: ERROR: invalid memory alloc request size 4294967292
Date
Msg-id 9171.1143127177@sss.pgh.pa.us
Whole thread Raw
In response to vacuumdb: ERROR: invalid memory alloc request size 4294967292  (Harco de Hilster <Harco.de.Hilster@ATConsultancy.nl>)
Responses Re: vacuumdb: ERROR: invalid memory alloc request size 4294967292  (Harco de Hilster <Harco.de.Hilster@ATConsultancy.nl>)
List pgsql-bugs
Tree view 
Harco de Hilster <Harco.de.Hilster@ATConsultancy.nl> writes:
> (gdb) bt
> #0  MemoryContextAlloc (context=0x8b3a10, size=4294967292) at mcxt.c:505
> #1  0x00000000004e06f9 in lazy_vacuum_rel (onerel=0x2a955ecbd8,
>     vacstmt=0x8bf390) at vacuumlazy.c:963

What do you have maintenance_work_mem set to?  If it's larger than 1Gb
you need to back it off, or apply this patch:
http://archives.postgresql.org/pgsql-committers/2006-03/msg00094.php

            regards, tom lane

pgsql-bugs by date:

Previous
From: Harco de Hilster
Date:
Subject: vacuumdb: ERROR: invalid memory alloc request size 4294967292
Next
From: Harco de Hilster
Date:
Subject: Re: vacuumdb: ERROR: invalid memory alloc request size 4294967292