Re: URGENT: Database keeps crashing - suspect damaged RAM

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: URGENT: Database keeps crashing - suspect damaged RAM
Дата
Msg-id Pine.LNX.4.33.0208061241230.1261-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Re: URGENT: Database keeps crashing - suspect damaged RAM  ("Markus Wollny" <Markus.Wollny@computec.de>)
Ответы Re: URGENT: Database keeps crashing - suspect damaged RAM  (Ralph Graulich <maillist@shauny.de>)
Список pgsql-general
A couple of points, one is that the linux kernel (if memory serves) is
limited to 2 gig swap partitions, but can have more than one swap.  In
fact, it is quite advantageous on a server that winds up swapping, to have
several partitions spread about on all the platters you can, as the kernel
will then interleave swap access across all the drives for maximum
performance.

What are your settings for sort_mem in postgresql?
Note that large values for sortmem can starve your machine for memory very
quickly, but only under load, and only when things need to be sorted.

I assume nothing like file-max or shmmax are the issue either?


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

Предыдущее
От: Ralph Graulich
Дата:
Сообщение: Re: View the contents of a database
Следующее
От: Darren Ferguson
Дата:
Сообщение: Re: how to get the primary key of a freshly inserted row