Horton

Re: Changing the default configuration (was Re:

Larry Rosenman <ler@lerctr.org>

View thread View on postgr.es
From: Larry Rosenman <ler@lerctr.org>
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>, "scott.marlowe" <scott.marlowe@ihs.com>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: Greg Copeland <greg@CopelandConsulting.Net>, PostgresSQL Hackers Mailing List <pgsql-hackers@postgresql.org>
Date: 2003-02-13T01:51:38Z
Lists: pgsql-hackers, pgsql-performance 

--On Thursday, February 13, 2003 09:47:28 +0800 Christopher Kings-Lynne 
<chriskl@familyhealth.com.au> wrote:

>> Seriously, I know Linux can change these on the fly, and I'm pretty sure
>> Solaris can too.  I haven't played with BSD for a while so can't speak
>> about that.  Anyone else know?
>
> You cannot change SHMMAX on the fly on FreeBSD.
Yes you can, on recent 4-STABLE:

Password:
lerlaptop# sysctl kern.ipc.shmmax=66000000
kern.ipc.shmmax: 33554432 -> 66000000
lerlaptop#uname -a
FreeBSD lerlaptop.lerctr.org 4.7-STABLE FreeBSD 4.7-STABLE #38: Mon Feb  3 
21:51:25 CST 2003 
ler@lerlaptop.lerctr.org:/usr/obj/usr/src/sys/LERLAPTOP  i386
lerlaptop#

>
> Chris
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>



-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749