Harco de Hilster <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings