Josué Maldonado wrote:
sort_mem = 131072 # min 64, size in KB
128 MB for sort_mem is really an huge ammount of memory considering that is not system-wide but almost for process ( under certain operations a single process can use more then this quantity ). Hackers: am I wrong ?
Not a hacker, but you're right. It's the amount of memory *per sort*. Of course, Josue might have a Terabyte of RAM but it's unlikely.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings