Re: Is there a significant difference in Memory settings between 9.5 and 12

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Is there a significant difference in Memory settings between 9.5 and 12
Дата
Msg-id 6776.1589232658@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Is there a significant difference in Memory settings between 9.5and 12  (Tory M Blue <tmblue@gmail.com>)
Список pgsql-general
Tory M Blue <tmblue@gmail.com> writes:
> Okay the one difference I see in settings is this little gem in 12..
> shared_memory_type mmap

Well, v12 is just exposing a switch for something that was hard-wired
before.  But now I wonder if your 9.5 installation could've been compiled
to force it to use SysV shmem instead of POSIX.  It would be pretty
unusual to have a system where the SysV shmem limits were higher than
the POSIX limits --- usually it's the other way 'round.  But this'd
explain why you're seeing a difference.

Does v12 start with the higher shared_buffers setting if you
set shared_memory_type = sysv?

            regards, tom lane



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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Is there a significant difference in Memory settings between 9.5and 12
Следующее
От: TalGloz
Дата:
Сообщение: Re: Upgrade Process Says "The database server was not shut downcleanly" but it was