Postgres Pro
Downloads
Home   >   mailing lists

shared_buffers on Big RAM systems - Mailing list pgsql-general

From Ron
Subject shared_buffers on Big RAM systems
Date
Msg-id b28c6930-5800-c821-95ee-0a065e6ff18e@gmail.com
Whole thread Raw
Responses Re: shared_buffers on Big RAM systems  (Rene Romero Benavides <rene.romero.b@gmail.com>)
Re: shared_buffers on Big RAM systems  (Thomas Munro <thomas.munro@enterprisedb.com>)
Re: shared_buffers on Big RAM systems  (Олег Самойлов <splarv@ya.ru>)
List pgsql-general
Tree view 
Hi,

https://www.postgresql.org/docs/9.6/runtime-config-resource.html

The docs say, "If you have a dedicated database server with 1GB or more of 
RAM, a reasonable starting value for shared_buffers is 25%".

But that's pretty archaic in 2018.  What if the dedicated database server 
has 128GB RAM?

Thanks.

-- 
Angular momentum makes the world go 'round.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pg_top error reporting?
Next
From: Kevin Brannen
Date:
Subject: why use phpPgAdmin (was: RE: Importing tab delimited text file usingphpPgAdmin 5.1 GUI)