Re: autovacuum worker running amok - and me too ;)

Поиск
Список
Период
Сортировка
От Karsten Hilbert
Тема Re: autovacuum worker running amok - and me too ;)
Дата
Msg-id 20150306101638.GC2843@hermes.hilbert.loc
обсуждение исходный текст
Ответ на Re: autovacuum worker running amok - and me too ;)  (wambacher <wnordmann@gmx.de>)
Ответы Re: autovacuum worker running amok - and me too ;)  (wambacher <wnordmann@gmx.de>)
Список pgsql-general
On Fri, Mar 06, 2015 at 02:39:34AM -0700, wambacher wrote:

> some comments:
>
> - the OOM did not kill the Postmaster but the Analyze-Job.
> - started with 24GB real and 18GB Swap - that must be enought! --> killed

"Back in the days" it was conventional wisdom to have twice
as much swap as you've got physical memory. Of course, I am
not suggesting you provide 48GB of swap and your problem is
magically solved _but_ one thing we might take away from that
old adage is that one might "hope things to work better"
(say, while debugging) if there is at least as much swap as
there is physical RAM based on the naive assumption that in
this case '"everything" can be swapped out'.

Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346


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

Предыдущее
От: Medhavi Mahansaria
Дата:
Сообщение: Re: #PERSONAL# Reg: date going as 01/01/0001
Следующее
От: wambacher
Дата:
Сообщение: Re: autovacuum worker running amok - and me too ;)