Re: Memory footprint diff between 9.5 and 12

Поиск
Список
Период
Сортировка
От Alan Hodgson
Тема Re: Memory footprint diff between 9.5 and 12
Дата
Msg-id 3ce4589dae05ec0f3308b0fb86f7a8a895e7b753.camel@lists.simkin.ca
обсуждение исходный текст
Ответ на Memory footprint diff between 9.5 and 12  (Tory M Blue <tmblue@gmail.com>)
Список pgsql-general
On Thu, 2020-05-07 at 13:33 -0700, Tory M Blue wrote:
I hadn't noticed this until today, but a running 9.5 system with buffers at 10GB starts and has been running years without issues. (15GB available)

Postgres 12 will not start with that configuration, complaining about memory availability.  So Postgres12 won't start until shared buffers is 6GB, but even with that, my DB servers , postgres queries started complaining about being unable to allocate memory "unable to allocate".

So dropping them to 4GB (on a 15GB system), may help, but did I miss a huge note about significant memory changes between 9.5 to 12?

Is there something else I'm missing that on busy systems is important, something introduced in 10 or 11 as again I'm not seeing anything noted in 12.
Thanks

Is this running on an otherwise identical system? Or do you have a different kernel, overcommit settings, or swap configuration?

В списке pgsql-general по дате отправления:

Предыдущее
От: github kran
Дата:
Сообщение: Re: AutoVacuum and growing transaction XID's
Следующее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: walreceiver termination