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
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? |