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

[Chris Hoover <chrish@xxxxxxxxxx>]

NP, it’s early on a Saturday here on the East Coast.  Just grateful for the assistance. :)

Thanks,

Chris Hoover

Senior DBA

AWeber.com

Cell: (803) 528-2269

Email: chrish@xxxxxxxxxx

On Feb 25, 2023, at 9:53 AM, MichaelDBA <MichaelDBA@xxxxxxxxxxx> wrote:

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@xxxxxxxxxxx> 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@xxxxxxxxxxx

703-600-9343

  
<pgadvanced3.jpg>