Hi,
On 2017-09-19 17:00:05 -0500, Jerry Sievers wrote:
> Briefly, just curious if legacy max values for shared_buffers have
> scaled up since 8G was like 25% of RAM?
It's very workload dependent. I've successfully used PG with roughly 1TB
of shared buffers, where that performed better than lower
settings.
> Pg 9.3 on monster 2T/192 CPU Xenial thrashing
Not sure what the word "thrashing" in that sentence means.
Things have improved a lot since 9.3 WRT to scalability, so I'd not
infer too much from 9.3 performance on a larger box.
> Upgrade pending but we recently started having $interesting performance
> issues at times looking like I/O slowness and other times apparently
> causing CPU spins.
That's not something we can really usefully comment on given the amount
of information.
> Anyway, shared_buffer coherency generally high but does take big dips
> that are sometimes sustained for seconds or even minutes.
"shared_buffer coherency"?
Greetings,
Andres Freund
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general