Re: How to monitor Postgres real memory usage

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема Re: How to monitor Postgres real memory usage
Дата
Msg-id 20220527175647.GG19626@telsasoft.com
обсуждение исходный текст
Ответ на How to monitor Postgres real memory usage  (徐志宇徐 <xuzhiyuster@gmail.com>)
Список pgsql-performance
On Sat, May 28, 2022 at 01:40:14AM +0800, 徐志宇徐 wrote:
> vm.swappiness=0

I think this is related to the problem.

swappiness=0 means to *never* use swap, even if that means that processes are
killed.

If you really wanted that, you should remove the swap space.

Swap is extremely slow and worth avoiding, but this doesn't let you use it at
all.  You can't even look at your swap usage as a diagnostic measure to tell if
things had been paged out at some point.

I *suspect* the problem will go away if you set swappiness=1 in /proc (and in
sysctl.conf).

-- 
Justin



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

Предыдущее
От: 徐志宇徐
Дата:
Сообщение: Re: How to monitor Postgres real memory usage
Следующее
От: Tom Lane
Дата:
Сообщение: Re: rows selectivity overestimate for @> operator for arrays