Re: PostgreSQL uses more memory on 6.1?

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-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).

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: Kernel Options
    ... > I am working with the Kernel config file to optimize it and also to ... Karol Kwiatkowski <freebsd at orchid dot homeunix dot org> ...
    (freebsd-questions)
  • Re: Power Off with ATX board wont work...
    ... if so add $acpi_load to your loader.conf file, and comment out the apm ... line in your kernel config file. ... To unsubscribe, ...
    (freebsd-questions)
  • Re: hw.crusoe sysctl missing
    ... > I just updated my Transmeta CrusoeLaptop to -CURRENT as of ... Add the following to your kernel config file and build/install kernel: ...
    (freebsd-current)
  • Re: OSS
    ... is it a configuration for compiling or at boot time? ... am linux user so will ... > the proper device entry is installed in your kernel config. ... > I need to add the following line to my kernel config file: ...
    (freebsd-questions)
  • Re: kernel fails to build on current (mga_g400_emit_tex0)
    ... >>make buildkernel ... > Usually you need to post your kernel config file when reporting ... but the kernel config worked before I cvsuped. ...
    (freebsd-current)