Re: out of memory woes

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: out of memory woes
Дата
Msg-id 9e4684ce0612182348p1ee1ad12p1414c877b77dd9b3@mail.gmail.com
обсуждение исходный текст
Ответ на Re: out of memory woes  ("Angva" <angvaw@gmail.com>)
Список pgsql-general
On 18 Dec 2006 07:16:56 -0800, Angva <angvaw@gmail.com> wrote:
The funny thing is that once it does fail, it fails consistently until
the server is bounced - I must have run the cluster script 10 times
after the initial failure. The server's 6g of RAM is normally more than
enough (so normally, maintenance_work_mem is not too high) until this
strange wall is hit. Another funny thing is that according to top, no
more than about 700k of swap is ever used - even when the problem
occurs - and the limit is 2g.

could you please show the configure options (shared buffers, work mem, and maintenance_work_mem), plus; what os you are running and on what architecture? i.e. 32bit? 64bit? xeon?

best regards,

depesz

--
http://www.depesz.com/ - nowy, lepszy depesz

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

Предыдущее
От: Shane Ambler
Дата:
Сообщение: Re: Let's play bash the search engine
Следующее
От: "Jeff Amiel"
Дата:
Сообщение: FreeBSD 6.0 PostgreSQL upgrade