Postgres Pro
Downloads
Home   >   mailing lists

Re: Setting Shared-Buffers - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Setting Shared-Buffers
Date
Msg-id 4A5700A50200002500028675@gw.wicourts.gov
Whole thread Raw
In response to Re: Setting Shared-Buffers  (Rafael Domiciano <rafael.domiciano@gmail.com>)
Responses Re: Setting Shared-Buffers
List pgsql-admin
Tree view 
Rafael Domiciano <rafael.domiciano@gmail.com> wrote:

> So, what's a good value to set to effective_cache_size with 10 Gb
> RAM?

It depends on how many other things you have on the system which are
using RAM, but probably something around 9GB would be appropriate.
Maybe even 9.5GB.

-Kevin

pgsql-admin by date:

Previous
From: Rafael Domiciano
Date:
Subject: Re: Setting Shared-Buffers
Next
From: Tino Schwarze
Date:
Subject: Re: Setting Shared-Buffers