Scott Marlowe <scott.marlowe@gmail.com> writes:
> On Tue, Sep 19, 2017 at 4:00 PM, Jerry Sievers <gsievers19@comcast.net> wrote:
>
>> 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.
>
> Have you looked at things like zone reclaim mode and transparent huge
> pages? Both of those can cause odd problems. Also it's usually a good
> idea to turn off swap as the linux kernel, presented with lots of ram
> and a small (by comparison) swap file sometimes makes bad life choices
> and starts using swap for things like storing currently unused shared
> buffers or something.
Not sure but we're checking into these items. Thanks
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general