Re: Out of memory on SELECT in 8.3.5

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Out of memory on SELECT in 8.3.5
Дата
Msg-id 20090209201538.GF8123@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: Out of memory on SELECT in 8.3.5  ("Matt Magoffin" <postgresql.org@msqr.us>)
Ответы Re: Out of memory on SELECT in 8.3.5  ("Matt Magoffin" <postgresql.org@msqr.us>)
Re: Out of memory on SELECT in 8.3.5  ("Matt Magoffin" <postgresql.org@msqr.us>)
Список pgsql-general
* Matt Magoffin (postgresql.org@msqr.us) wrote:
> [root@170226-db7 ~]# cat /proc/meminfo
> CommitLimit:  10312588 kB
> Committed_AS:  9760756 kB

I suspect this may be it...  Apparently, while you're only using about
2G, you've got 10G or so of outstanding commitments, and Linux is
refusing to allocate more.

You probably want to up your overcommit_ratio, esp. in light of the fact
that you've only got 2G of swap on this box.  I'd probably say up it to
80, which would give you 14.8G of commitable memory, leaving some room
in-memory (1.2G) for cache/buffers and whatnot.  Alternativly, you could
go for 90, which would allow commits up to 16.4G, so if everyone used
all their memory, you'd be into swap.

    Enjoy,

        Stephen

Вложения

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

Предыдущее
От: "Matt Magoffin"
Дата:
Сообщение: Re: Out of memory on SELECT in 8.3.5
Следующее
От: "Matt Magoffin"
Дата:
Сообщение: Re: Out of memory on SELECT in 8.3.5