On 4/6/04 11:09 PM, "Tom Lane" <tgl@sss.pgh.pa.us> wrote: > What "out of memory thing"? The tuplestore code is perfectly capable of > spilling to disk --- in fact the usual performance gripe against it has > to do with spilling too soon, because sort_mem is set too small. I tried doing a mass update of all rows with a single SQL statement in psql and after it ran for many hours, I got 'out of memory'. I didn't try that using C and WITH HOLD. I assumed it ran out of swap space, but was sleeping at the time. Wes ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
