From owner-freebsd-hackers Fri Mar 20 12:26:15 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id MAA17420 for freebsd-hackers-outgoing; Fri, 20 Mar 1998 12:26:15 -0800 (PST) (envelope-from owner-freebsd-hackers@FreeBSD.ORG) Received: from sendero.simon-shapiro.org (sendero-fddi.Simon-Shapiro.ORG [206.190.148.2]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id MAA17265 for ; Fri, 20 Mar 1998 12:25:56 -0800 (PST) (envelope-from shimon@simon-shapiro.org) Received: (qmail 25585 invoked from network); 20 Mar 1998 20:32:19 -0000 Received: from localhost.simon-shapiro.org (HELO sendero-fxp0.simon-shapiro.org) (@127.0.0.1) by localhost.simon-shapiro.org with SMTP; 20 Mar 1998 20:32:19 -0000 Message-ID: X-Mailer: XFMail 1.3-alpha-031298 [p0] on FreeBSD X-Priority: 3 (Normal) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit MIME-Version: 1.0 In-Reply-To: <199803181718.LAA08905@soccer.inetspace.com> Date: Fri, 20 Mar 1998 12:32:19 -0800 (PST) Reply-To: shimon@simon-shapiro.org Organization: The Simon Shapiro Foundation From: Simon Shapiro To: "Kent S. Gordon" Subject: Re: How do you increase available SYSV shared memory? Cc: roberto@keltia.freenix.fr, freebsd-hackers@FreeBSD.ORG Sender: owner-freebsd-hackers@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG 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. Sion To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-hackers" in the body of the message