Re: New PG14 server won't start with >2GB shared_buffers
| От | Jeff Janes |
|---|---|
| Тема | Re: New PG14 server won't start with >2GB shared_buffers |
| Дата | |
| Msg-id | CAMkU=1xiP6vAL+Lc74+4f=wLkgj2cV4snBxvMyhDk+pr9z9Ddg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: New PG14 server won't start with >2GB shared_buffers (MichaelDBA <MichaelDBA@sqlexec.com>) |
| Ответы |
Re: New PG14 server won't start with >2GB shared_buffers
|
| Список | pgsql-admin |
On Sat, Feb 25, 2023 at 9:05 AM MichaelDBA <MichaelDBA@sqlexec.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
В списке pgsql-admin по дате отправления: