Re: PostgreSQL uses more memory on 6.1?

On Tuesday 23 May 2006 05:13 pm, Jung-uk Kim wrote:
On Tuesday 23 May 2006 04:58 pm, Kirk Strauser wrote:
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-messag
e- 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).

kern.ipc.shmmaxpgs?

I meant 'kern.ipc.shmall', which used to be 'kern.ipc.shmmaxpgs'. :-(

Jung-uk Kim
_______________________________________________
freebsd-stable@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-stable
To unsubscribe, send any mail to "freebsd-stable-unsubscribe@xxxxxxxxxxx"

Relevant Pages

  • Re: PostgreSQL uses more memory on 6.1?
    ... On Tuesday 23 May 2006 05:19 pm, Jung-uk Kim wrote: ... ag e- server for what to add to your kernel config. ... neither of those files (or even my kernel config ... Okay, I don't know what I am talking about here. ...
    (freebsd-stable)
  • Re: lost /dev/agpgart , X11 confused.
    ... Yeah, my X server seems upset about it, all right. ... Am I not loading a module or device in my kernel config? ... # Add suspend/resume support for the i8254. ... # The `bpf' device enables the Berkeley Packet Filter. ...
    (freebsd-current)
  • ipfw question
    ... I have a quick question ipfw in a 4.8 server.. ... in the kernel config leaves it ... Outgoing mail is certified Virus Free. ...
    (FreeBSD-Security)
  • Re: HZ kernel option
    ... Chad Leigh -- Shire.Net LLC wrote: ... > kernel config. ... > exim, php, some java (server stuff), perl, and then ssh command line ... To unsubscribe, ...
    (freebsd-questions)
  • Re: OpenVPN and IPF
    ... OpenVPN I would see a corresponding tun0, tun1, etc. as required. ... my kernel config. ... any traffic destined for 10.8/24 matches the default route on the client. ... But, if the server is the router at 192.168.1.4, then the traffic may either be dropped or return traffic routed through the tunnel. ...
    (comp.unix.bsd.freebsd.misc)