Re: postmaster crashing

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: psql-mail(at)freeuk(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: postmaster crashing
Date: 2003-09-05 14:42:19
Message-ID: 13661.1062772939@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

psql-mail(at)freeuk(dot)com writes:
> The server has 4GB of memory and is not running any other services - so
> i wouldn't expect there to be memory shortage problems.

That has nothing whatever to do with how much memory the kernel will let
any one process have. Check what ulimit settings the postmaster is
running under (particularly -d, -m, -v).

> I have since changed the kernel settings to allow 1GB of shared mem and
> changed shared_buffers in postgresql.conf to request just under that.

If anything, that's counterproductive for this problem. I'm not sure
whether shared memory is counted against your ulimit -d, but it might
be.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-09-05 14:48:29 Re: default EXECUTE privilege
Previous Message Jonathan Bartlett 2003-09-05 14:39:49 Re: Seq scan of table?