From: | Joe Koenig <joe(at)jwebmedia(dot)com> |
---|---|
To: | pgsql General List <pgsql-general(at)postgresql(dot)org> |
Subject: | How to increase shared mem for PostgreSQL on FreeBSD |
Date: | 2001-12-13 16:42:14 |
Message-ID: | 3C18DA67.6554AC49@jwebmedia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
My system is FreeBSD 4.3 with 1GHz P3, 1GB RAM, SCSI RAID 5. I read an
article on PHPBuilder about optimizing PostgreSQL - one big thing was
increasing shared memory. I asked on the FreeBSD mailing list and got
different suggestions as to how to increase the shared memory - my main
question is - do I need to rebuild my kernel? I used sysctl -w
shmall=131072 to up my shared mem, then edited postgresql.conf to show:
shared_buffers = 15200
sort_mem = 32168
and postgres wouldn't start. I assume that means the shared buffers is
actually larger than the amount of shared mem, so it appears the sysctl
didn't really do anything. If I comment out the shared_buffers line,
postgres will start, but upping the sort mem doesn't help my insert
speed. Can anyone help me out with how to get the shared mem increased
so I can up the shared_buffers in postgres? Thanks,
Joe
From | Date | Subject | |
---|---|---|---|
Next Message | Masaru Sugawara | 2001-12-13 16:42:47 | Re: excessive performance difference |
Previous Message | Antonio Fiol Bonnín | 2001-12-13 15:37:25 | Re: Select .. Having vs computer fields |