> Wrong, actually.   Sort memory is allocated *per sort*, not per
connnection or
> per query.   So a single complex query could easily use 4xsort_mem if it
> several merge joins ...

Thanks for the correction- it sounds like this is one where usage can't be
precisely controlled in a dynamic user environment & I just need to get a
feel for what works under a load that approximates my production system.


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to