I
just don't get what all this fuss is about
trying to get PG up on the smallest possible values for shared_buffers,
especially considering this person has 1 TB of memory?
The
fuss is why he can't make it bigger. No one wants to make it as small
as possible.
Chris Hoover wrote on 2/25/2023 8:07 AM:
Here is shmall:
kernel.shmall
= 17179869184
How
did that get so small? On my Ubuntu18.04, it comes out of the box at
2^64 - 1. Why would anyone have set about making it smaller? Now the
current value should still be big enough, but I wonder what else got
changed while someone was monkeying with things that didn't need to be
monkeyed with.
Cheers,
Jeff
