On Tue, Dec 27, 2011 at 1:00 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> He can lower it for just that query but honestly, even on a machine
> with much more memory I'd never set it as high as he has it. On a
> busy machine with 128G RAM the max I ever had it set to was 16M, and
> that was high enough I kept a close eye on it (well, nagios did
> anway.)
I have it quite high, because I know the blend of queries going into
the server allows it.
But yes, it's not a sensible setting if you didn't analyze the
activity carefully.