Return-Path: owner-postman Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id MAA00340 for postgres-redist; Sat, 19 Nov 1994 12:58:03 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199411192058.MAA00340@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from voodoo.oec.com (voodoo.oec.com [198.3.137.31]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with ESMTP id MAA00330 for ; Sat, 19 Nov 1994 12:58:02 -0800 Received: (from stewart@localhost) by voodoo.oec.com (8.6.9/8.6.9) id RAA01425; Sat, 19 Nov 1994 17:02:09 -0500 Date: Sat, 19 Nov 1994 17:02:08 -0500 (EST) From: Stewart Allen To: "Paul M. Aoki" cc: Postgres Group Subject: Re: Postgres and raw devices In-Reply-To: <199411192003.MAA00653@faerie.CS.Berkeley.EDU> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Sat, 19 Nov 94 12:58:03 -0800 Resent-XMts: smtp On Sat, 19 Nov 1994, Paul M. Aoki wrote: > Stewart Allen writes: > > I once heard it rumored that Postgres supported using raw block > > devices instead of UFS. Is there any truth to this? > > the standard postgres magnetic disk interface uses UFS. > > people have developed various experimental optical disk jukebox > storage managers on top of raw device interfaces, but i doubt that's > what you meant. I was thinking more along the lines of Informix Online, Sybase, and Oracle which support raw partitions. This eliminates the overhead of sitting on top of a filesystem, but introduces a great deal of complexity in management. This occured to me for two reasons: 1) I want to implement a logical volume manager under Linux with features such as volume striping and other exotic performance enhancements. Raw devices would provide a tremendous speed enhancement with this. 2) I've just completed a port of our Encompass toolkit to Linux in which I added support for Postgres database servers. This means Postgres can now be integrated into 3-tier client/server packages with PC's, Macs, and any other Unix boxes as clients. I was looking for a slight performance increase for a demo (not that Postgres doesn't already perform admirably) These guys are used to Oracle on Alphas. -- - Stewart Allen * stewart@oec.com * 617.562.5826 * FAX 617.562.0038 - -- M.I.S. Manager * Open Environment Corporation * 617.562.0900 25 Travis St * Boston, Ma * 02134 -- - -- - -- - -- "That's my story and I'm stickin' to it" -- - -- - -- - -- ============================================================================== To add/remove yourself to/from the POSTGRES mailing list: send mail with the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU". If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and a human will deal with it. DO NOT post to the "postgres" mailing list. ============================================================================== URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/