Re: vacuumdb: ERROR: invalid memory alloc request size 4294967292

From: Harco de Hilster <Harco(dot)de(dot)Hilster(at)ATConsultancy(dot)nl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: vacuumdb: ERROR: invalid memory alloc request size 4294967292
Date: 2006-03-23 16:02:37
Message-ID: 4422C69D.30109@ATConsultancy.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

That did the trick. Thanks.

Kind regards,

Harco

Tom Lane wrote:

>Harco de Hilster <Harco(dot)de(dot)Hilster(at)ATConsultancy(dot)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
>
>
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Carlos Rivas 2006-03-23 23:25:02 Error in ecpg
Previous Message Tom Lane 2006-03-23 15:19:37 Re: vacuumdb: ERROR: invalid memory alloc request size 4294967292