Re: PostgreSQL uses more memory on 6.1?
- From: Kirk Strauser <kirk@xxxxxxxxxxxx>
- Date: Tue, 23 May 2006 15:58:26 -0500
On Tuesday 23 May 2006 15:37, Marshall Pierce wrote:
You need to adjust the shared memory segments allowed by the kernel; see
/usr/ports/databases/postgresql<your-version>-server/pkg-message-server
for what to add to your kernel config. Most likely, you forgot to move
over your kernel customizations to your new kernel...?
Nope, I took care of that:
/etc/sysctl.conf:
kern.ipc.semmap=256
kern.ipc.shmmax=268435456
/boot/loader.conf
kern.ipc.semmni="256"
kern.ipc.semmns="512"
kern.ipc.semmnu="256"
Furthermore, neither of those files (or even my kernel config file) changed
between the previous reboot and the one that installed 6.1. At any rate,
the kern.ipc.shmmax is much, much greater than the 64MB that I'd been using
before for shared_buffers (8192 buffers * 8 KB/buffer).
--
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"
- Follow-Ups:
- Re: PostgreSQL uses more memory on 6.1?
- From: Jung-uk Kim
- Re: PostgreSQL uses more memory on 6.1?
- From: Claus Guttesen
- Re: PostgreSQL uses more memory on 6.1?
- References:
- PostgreSQL uses more memory on 6.1?
- From: Kirk Strauser
- Re: PostgreSQL uses more memory on 6.1?
- From: Marshall Pierce
- 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
|
|
