Skip site navigation (1) Skip section navigation (2)

Re: Exploring memory usage

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 (view raw or flat)
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.

In response to

pgsql-performance by date

Next:From: Andrew DunstanDate: 2011-12-27 16:14:40
Subject: Re: Exploring memory usage
Previous:From: Scott MarloweDate: 2011-12-27 16:00:20
Subject: Re: Exploring memory usage

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group