Re: URGENT: Database keeps crashing - suspect damaged RAM - Mailing list pgsql-general

From scott.marlowe
Subject Re: URGENT: Database keeps crashing - suspect damaged RAM
Date
Msg-id Pine.LNX.4.33.0208061241230.1261-100000@css120.ihs.com
Whole thread Raw
In response to Re: URGENT: Database keeps crashing - suspect damaged RAM  ("Markus Wollny" <Markus.Wollny@computec.de>)
Responses Re: URGENT: Database keeps crashing - suspect damaged RAM  (Ralph Graulich <maillist@shauny.de>)
List 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 by date:

Previous
From: Ralph Graulich
Date:
Subject: Re: View the contents of a database
Next
From: Darren Ferguson
Date:
Subject: Re: how to get the primary key of a freshly inserted row