On Feb 14, 2004, at 9:02 PM, Marinos J. Yannikos wrote:
Josh Berkus wrote:
800MB for sort mem? Are you sure you typed that correctly? You
must be counting on not having a lot of concurrent queries. It sure
will speed up index updating, though!
800MB is correct, yes... There are usually
Jeff Trout wrote:
Remember that it is going to allocate 800MB per sort. It is not you
can allocate up to 800MB, so if you need 1 meg, use one meg. Some
queries may end up having a few sort steps.
I didn't know that it always allocates the full amount of memory
specificed in the configuration