| From: | Claudio Freire <klaussfreire(at)gmail(dot)com> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | Michael Smolsky <sitrash(at)email(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Exploring memory usage |
| Date: | 2011-12-27 16:06:46 |
| Message-ID: | CAGTBQpbKuUiD_dxuL7dQuWy5P8A4yT3EEakSqjM0XDWHKuMVgw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, Dec 27, 2011 at 1:00 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2011-12-27 16:14:40 | Re: Exploring memory usage |
| Previous Message | Scott Marlowe | 2011-12-27 16:00:20 | Re: Exploring memory usage |