Re: URGENT: Database keeps crashing - suspect damaged RAM

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Markus Wollny <Markus(dot)Wollny(at)computec(dot)de>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: URGENT: Database keeps crashing - suspect damaged RAM
Date: 2002-08-06 18:51:03
Message-ID: Pine.LNX.4.33.0208061241230.1261-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff MacDonald 2002-08-06 18:52:28 Re: starting with postgresql
Previous Message John Gray 2002-08-06 18:50:21 Re: Cannot use more than 16 attributes in an index