On Tue, Dec 27, 2011 at 1:00 PM, Scott Marlowe <scott.marl...@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. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
