agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedFrom: Stewart Allen <stewart@oec.com>
To: Paul M. Aoki <aoki@cs.berkeley.edu>
Cc: Postgres Group <postgres@postgres.Berkeley.EDU>
Subject: Re: Postgres and raw devices
Date: Sat, 19 Nov 1994 17:02:08 -0500 (EST)
Message-ID: <Pine.LNX.3.91.941119164844.1185B-100000@voodoo.oec.com> (raw)
In-Reply-To: <199411192003.MAA00653@faerie.CS.Berkeley.EDU>
On Sat, 19 Nov 1994, Paul M. Aoki wrote:
> Stewart Allen <stewart@oec.com> 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/
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: postgres@postgres.berkeley.edu
Cc: stewart@oec.com, aoki@cs.berkeley.edu
Subject: Re: Postgres and raw devices
In-Reply-To: <Pine.LNX.3.91.941119164844.1185B-100000@voodoo.oec.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox