Re: PostgreSQL uses more memory on 6.1?
- From: Kirk Strauser <kirk@xxxxxxxxxxxx>
- Date: Tue, 23 May 2006 16:17:12 -0500
On Tuesday 23 May 2006 16:05, Claus Guttesen wrote:
He probably meant the following kernel-settings:
options SHMMAXPGS=393216
options SEMMNI=240
options SEMMNS=1440
options SEMUME=240
options SEMMNU=720
Those are for my quad-opteron server with 8 GB RAM. Adjust
accordingly. Did you compile a custom-build-kernel or GENERIC?
I hadn't compiled any of those into my custom kernel, as per some now
long-forgotten web page that said I should use the sysctls to reach the
same effect.
What I'd *really* like to find is an explanation of how to set those
numbers. I'm using a single Xeon with 3GB of RAM and have no idea how high
to set those, or whether a particular value is too high. Then again, once
I figure it out I guess I should have a fair amount of job security. :-)
--
Kirk Strauser
_______________________________________________
freebsd-stable@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-stable
To unsubscribe, send any mail to "freebsd-stable-unsubscribe@xxxxxxxxxxx"
- References:
- PostgreSQL uses more memory on 6.1?
- From: Kirk Strauser
- Re: PostgreSQL uses more memory on 6.1?
- From: Kirk Strauser
- Re: PostgreSQL uses more memory on 6.1?
- From: Claus Guttesen
- PostgreSQL uses more memory on 6.1?
- Prev by Date: Re: PostgreSQL uses more memory on 6.1?
- Next by Date: Re: PostgreSQL uses more memory on 6.1?
- Previous by thread: Re: PostgreSQL uses more memory on 6.1?
- Next by thread: Re: PostgreSQL uses more memory on 6.1?
- Index(es):
Relevant Pages
|
|
