Postgres Pro
Downloads
Home   >   mailing lists

Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average - Mailing list pgsql-performance

From Josh Berkus
Subject Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average
Date
Msg-id 5614AF06.1050502@agliodbs.com
Whole thread Raw
In response to shared-buffers set to 24GB but the RAM only use 4-5 GB average  (FattahRozzaq <ssoorruu@gmail.com>)
List pgsql-performance
Tree view 
On 10/06/2015 02:33 AM, FattahRozzaq wrote:
> @Merlin Moncure, I got the calculation using pg_tune. And I modified
> the shared_buffers=24GB and the effective_cache_size=64GB

I really need to get Greg to take down pg_tune. It's way out of date.

Probably, I should replace it.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

pgsql-performance by date:

Previous
From: ajaykbs
Date:
Subject: Re: Multi processor server overloads occationally with system process while running postgresql-9.4
Next
From: Scott Marlowe
Date:
Subject: Re: Re: Multi processor server overloads occationally with system process while running postgresql-9.4