From: | "Robert B(dot) Easter" <reaster(at)comptechnews(dot)com> |
---|---|
To: | joe(at)jwebmedia(dot)com, pgsql General List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How to increase shared mem for PostgreSQL on FreeBSD |
Date: | 2001-12-13 19:07:39 |
Message-ID: | 200112131907.fBDJ7dd28208@comptechnews.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
There is info in the Administrator's Guide that might help:
http://www.postgresql.org/idocs/index.php?kernel-resources.html
Bob
On Thursday 13 December 2001 11:42 am, Joe Koenig wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2001-12-13 19:22:12 | Re: Can I call unix/linux commands within plsql? |
Previous Message | Chris Albertson | 2001-12-13 18:55:28 | Re: slow queries on large syslog table |