Re: New PG14 server won't start with >2GB shared_buffers

I sincerely apologize.  I should have read this stuff more closely.

Jeff Janes wrote on 2/25/2023 9:51 AM:
> On Sat, Feb 25, 2023 at 9:05 AM MichaelDBA <MichaelDBA(at)sqlexec(dot)com
> <mailto:MichaelDBA(at)sqlexec(dot)com>> wrote:
>
> 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

Regards,

Michael Vitale

Michaeldba(at)sqlexec(dot)com <mailto:michaelvitale(at)sqlexec(dot)com>

703-600-9343