Jeff Amiel <becauseimjeff@xxxxxxxxx> writes: > Aug 22 18:08:24 db-1 postgres[16452]: [ID 748848 > local0.warning] [6-1] 2007-08-22 18:08:24 CDT ERROR: > out of memory. > Aug 22 18:08:24 db-1 postgres[16452]: [ID 748848 > local0.warning] [6-2] 2007-08-22 18:08:24 CDT > DETAIL: Failed on request of size 536870910. > What I found interesting is that It's ALWAYS the same > size....536870910 > maintenance_work_mem = 512MB # min 1MB Apparently this maintenance_work_mem setting is higher than your system can reliably provide. Knock it back a bit. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/