X-Original-To: pgsql-hackers@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id EA7C0475C8B for ; Wed, 12 Feb 2003 20:52:27 -0500 (EST) Received: from lerami.lerctr.org (lerami.lerctr.org [207.158.72.11]) by postgresql.org (Postfix) with ESMTP id ECAEF475458 for ; Wed, 12 Feb 2003 20:52:07 -0500 (EST) Received: from lerlaptop.lerctr.org (lerlaptop.lerctr.org [207.158.72.14]) (authenticated bits=0) by lerami.lerctr.org (8.12.7/8.12.7/20030207) with ESMTP id h1D1pcxE016717; Wed, 12 Feb 2003 19:51:39 -0600 (CST) Date: Wed, 12 Feb 2003 19:51:38 -0600 From: Larry Rosenman To: Christopher Kings-Lynne , "scott.marlowe" , Tom Lane Cc: Greg Copeland , PostgresSQL Hackers Mailing List Subject: Re: Changing the default configuration (was Re: Message-ID: <58760000.1045101098@lerlaptop.lerctr.org> In-Reply-To: References: X-Mailer: Mulberry/3.0.1 (Linux/x86) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: by amavisd-milter (http://amavis.org/) X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/522 X-Sequence-Number: 35464 --On Thursday, February 13, 2003 09:47:28 +0800 Christopher Kings-Lynne 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