From: | Jerry Sievers <gsievers19(at)comcast(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Up to date conventional wisdom re max shared_buffer size? |
Date: | 2017-09-19 22:00:05 |
Message-ID: | 87zi9qmjru.fsf@jsievers.enova.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Briefly, just curious if legacy max values for shared_buffers have
scaled up since 8G was like 25% of RAM?
Pg 9.3 on monster 2T/192 CPU Xenial thrashing
Upgrade pending but we recently started having $interesting performance
issues at times looking like I/O slowness and other times apparently
causing CPU spins.
The DB is 10TB total size with OLTP plus some occasional heavy batching
which frequently correlates with degradation that requires intervention.
Unrelated server problem forced us to relocate from a Debian/Wheezy 3.x
kernel 1T 144 CPU to the even bigger box mentioned earlier. And we wen
up a major kernel version also in the process.
Anyway, shared_buffer coherency generally high but does take big dips
that are sometimes sustained for seconds or even minutes.
shared_buffers only 20G which is relatively very small vs total machine
RAM however we do not have the luxury of scheduled downtime so this and
other settings requiring a full restart are not touched without good
reason.
Thanks
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres(dot)consulting(at)comcast(dot)net
p: 312.241.7800
From | Date | Subject | |
---|---|---|---|
Next Message | chiru r | 2017-09-19 22:32:09 | Re: [HACKERS] USER Profiles for PostgreSQL |
Previous Message | Bruce Momjian | 2017-09-19 20:00:54 | Re: pgcrypto encrypt |