From owner-freebsd-hackers Fri Mar 20 13:21:03 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id NAA27637 for freebsd-hackers-outgoing; Fri, 20 Mar 1998 13:21:03 -0800 (PST) (envelope-from owner-freebsd-hackers@FreeBSD.ORG) Received: from ns1.yes.no (ns1.yes.no [195.119.24.10]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id NAA27557 for ; Fri, 20 Mar 1998 13:20:50 -0800 (PST) (envelope-from eivind@bitbox.follo.net) Received: from bitbox.follo.net (bitbox.follo.net [194.198.43.36]) by ns1.yes.no (8.8.7/8.8.7) with ESMTP id VAA04529; Fri, 20 Mar 1998 21:19:36 GMT Received: (from eivind@localhost) by bitbox.follo.net (8.8.6/8.8.6) id WAA13354; Fri, 20 Mar 1998 22:19:32 +0100 (MET) Message-ID: <19980320221931.51710@follo.net> Date: Fri, 20 Mar 1998 22:19:31 +0100 From: Eivind Eklund To: shimon@simon-shapiro.org, "Kent S. Gordon" Cc: roberto@keltia.freenix.fr, freebsd-hackers@FreeBSD.ORG Subject: Re: How do you increase available SYSV shared memory? References: <199803181718.LAA08905@soccer.inetspace.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.89.1i In-Reply-To: ; from Simon Shapiro on Fri, Mar 20, 1998 at 12:32:19PM -0800 Sender: owner-freebsd-hackers@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Fri, Mar 20, 1998 at 12:32:19PM -0800, Simon Shapiro wrote: > > On 18-Mar-98 Kent S. Gordon wrote: > > > >>>>>> "shimon" == Simon Shapiro writes: > > I have been thinking of changing Postgres to use mmapped files instead > > of SYSV shared memory. I think this should allow for larger postgres > > This will be a disaster. It assumes that PostgreSQL uses files for data > storage. While this is the default mode, it is NOT the only storage > meanager. In PostgreSQL, like most true RDBMS, the storage of data is > decoupled from the logic of the relational model, etc. I am building a > storage manager that uses a totally different (distributed) storage model > than Unix files. A memory based storage manager already exists in > PostgreSQL. Please do not break these. I don't think you're quite getting him (or I'm not getting you at all). mmap()ing /dev/zero is a common way of getting hold of shared memory, instead of using the SYSV SHMEM extension. mmap'ing usually works better. This is just replacing one technique for getting hold of shared memory with another; it does nothing to the storage manager. Eivind. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-hackers" in the body of the message