Re: Maxium Share Memory in Debian 64bit

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Maxium Share Memory in Debian 64bit
Date: 2012-02-24 19:46:00
Message-ID: 4F47E8F8.4090108@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 02/24/12 11:41 AM, Prashant Bharucha wrote:
> Hello All
>
> Could you please help to figure out how much maxium memory can
> allocated in Shared Memory on Debian 64 bit OS ?
>

I rarely set shared_buffers over about 2GB even on machines with 48GB or
more ram. its a case of diminishing returns, and leaving that extra
memory available for OS file system caching (as well as non-shared
things like work_mem, maintenance_work_mem) is usually the better choice.

--
john r pierce N 37, W 122
santa cruz ca mid-left coast

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Igor Neyman 2012-02-24 19:58:09 Re: Stability in Windows?
Previous Message Willem Buitendyk 2012-02-24 19:43:11 Re: Upgrade to 9.1 causing function problem