From owner-freebsd-stable Thu Jul 11 2:51: 9 2002 Delivered-To: freebsd-stable@freebsd.org Received: from mx1.FreeBSD.org (mx1.FreeBSD.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 39F0437B400 for ; Thu, 11 Jul 2002 02:51:04 -0700 (PDT) Received: from paprika.michvhf.com (adsl-67-36-71-182.dsl.sfldmi.ameritech.net [67.36.71.182]) by mx1.FreeBSD.org (Postfix) with SMTP id 4B23F43E3B for ; Thu, 11 Jul 2002 02:51:03 -0700 (PDT) (envelope-from vev@michvhf.com) Received: (qmail 2280 invoked by uid 1001); 11 Jul 2002 09:51:00 -0000 Date: Thu, 11 Jul 2002 05:51:00 -0400 (EDT) From: Vince Vielhaber To: Vivek Khera Cc: stable@freebsd.org, Subject: Re: [GENERAL] was there a change in FreeBSD SHM implementation from 4.4 to 4.6? (postgres trouble) In-Reply-To: <15660.31149.224797.969563@onceler.kciLink.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-stable@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On Wed, 10 Jul 2002, Vivek Khera wrote: > -- cut here -- > IpcMemoryCreate: shmget(key=5432001, size=665346048, 03600) failed: Cannot allocate memory > > This error usually means that PostgreSQL's request for a shared > memory segment exceeded available memory or swap space. > To reduce the request size (currently 665346048 bytes), reduce > PostgreSQL's shared_buffers parameter (currently 80000) and/or > its max_connections parameter (currently 48). > -- cut here -- > > > Now, by my arithmetic, 665346048 is certainly less than 1073741824 by > quite a bit. > > I did not recompile postgres after the FreeBSD upgrade. > > Has something changed from 4.4-STABLE that would cause such a failure? > > The funny thing is that it worked just fine with FBSD 4.4 and the > lower setting of shmmax (even with 100000 shared_buffers), so > something is making postgres try to allocate a larger hunk of memory. > I just don't know what. > > Any advice would be appreciated. Have you looked at the FreeBSD section here: http://www.postgresql.org/idocs/index.php?kernel-resources.html Most notably, I had to increase SHMMAXPGS on one of my FreeBSD machines. There doesn't appear to be a sysctl variable for it. Vince. -- ========================================================================== Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directory http://www.camping-usa.com Online Giftshop Superstore http://www.cloudninegifts.com ========================================================================== To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-stable" in the body of the message