Re: Suggested swap size for new db?

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: Suggested swap size for new db?
Дата
Msg-id AANLkTi=gdnnVOS5kXCD+E__mBiyC0TKx9=8C8Zz1j=k+@mail.gmail.com
обсуждение исходный текст
Ответ на Suggested swap size for new db?  ("Evan D. Hoffman" <evandhoffman@gmail.com>)
Список pgsql-general
On Sun, Nov 14, 2010 at 10:34 PM, Evan D. Hoffman
<evandhoffman@gmail.com> wrote:
> as part of another project) running on CentOS 5.4 or 5.5.  I know the
> old rule of thumb that your swap partition/disk should be equal to the
> physical memory, but when dealing with memory sizes greater than ~16
> GB that starts to seem strange to me; and now with 96 GB of physical
> memory I'm starting to wonder if I'd be better off forgoing swap
> altogether for the new database.
>

The "old" rule is swap = 3x RAM. But those were the days of 64MB RAM
being an extravagance. :)

What I currently do is try to make swap = RAM + delta, so that if
(when?) the machine panics I can get a useful kernel panic core dump.
Given that boot drives are ~1TB these days, that's not a big deal.

Machines running large RAM like that should never swap, else the point
of having that much RAM is lost, and you probably needed more RAM to
handle your workload than you anticipated.

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

Предыдущее
От: Malm Paul
Дата:
Сообщение: postgreSQL-devel 8.3.8
Следующее
От: Vick Khera
Дата:
Сообщение: Re: where is pg_stat_activity (and others) in the documentation?