| From: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> |
|---|---|
| To: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
| Cc: | Forums postgresql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: shared_buffers on Big RAM systems |
| Date: | 2018-12-14 04:51:09 |
| Message-ID: | CAEepm=1x+b1ac0Y1Ft7MbMW+0JQnX7RKWEo8eRJsfDbWvLwG0A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Dec 14, 2018 at 2:17 AM Ron <ronljohnsonjr(at)gmail(dot)com> wrote:
> 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?
I agree, we might as well drop the words "with 1GB of more of RAM".
That's the size of the very smallest cloud instances available these
days, available for free or up to a few bucks a month, and for
physical servers I wonder if you can still get DIMMs that small.
--
Thomas Munro
http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2018-12-14 06:00:09 | Installing pg_buffercache (was Re: shared_buffers on Big RAM systems) |
| Previous Message | Rene Romero Benavides | 2018-12-14 02:25:28 | Re: shared_buffers on Big RAM systems |