Quick Links

shared_buffers on Big RAM systems

From:	Ron <ronljohnsonjr(at)gmail(dot)com>
To:	"pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject:	shared_buffers on Big RAM systems
Date:	2018-12-13 15:17:43
Message-ID:	b28c6930-5800-c821-95ee-0a065e6ff18e@gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

Hi,

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.

Re: shared_buffers on Big RAM systems at 2018-12-14 02:25:28 from Rene Romero Benavides
Re: shared_buffers on Big RAM systems at 2018-12-14 04:51:09 from Thomas Munro
Re: shared_buffers on Big RAM systems at 2019-04-11 11:05:27 from Олег Самойлов

	From	Date	Subject
Next Message	Kevin Brannen	2018-12-14 00:08:46	why use phpPgAdmin (was: RE: Importing tab delimited text file using phpPgAdmin 5.1 GUI)
Previous Message	Adrian Klaver	2018-12-13 15:11:50	Re: pg_top error reporting?