agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedRe: Postgres and raw devices
3+ messages / 2 participants
[nested] [flat]
* Postgres and raw devices
@ 1994-11-19 20:13 Stewart Allen <stewart@oec.com>
1994-11-19 20:03 ` Re: Postgres and raw devices Paul M. Aoki <aoki@cs.berkeley.edu>
0 siblings, 1 reply; 3+ messages in thread
From: Stewart Allen @ 1994-11-19 20:13 UTC (permalink / raw)
To: legacy
I once heard it rumored that Postgres supported using raw block devices
instead of UFS. Is there any truth to this?
-- - 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/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgres and raw devices
1994-11-19 20:13 Postgres and raw devices Stewart Allen <stewart@oec.com>
@ 1994-11-19 20:03 ` Paul M. Aoki <aoki@cs.berkeley.edu>
1994-11-19 22:02 ` Re: Postgres and raw devices Stewart Allen <stewart@oec.com>
0 siblings, 1 reply; 3+ messages in thread
From: Paul M. Aoki @ 1994-11-19 20:03 UTC (permalink / raw)
To: Stewart Allen <stewart@oec.com>; +Cc: legacy
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.
--
Paul M. Aoki | University of California at Berkeley
aoki@CS.Berkeley.EDU | Dept. of EECS, Computer Science Division (#1776)
| Berkeley, CA 94720-1776
==============================================================================
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/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgres and raw devices
1994-11-19 20:13 Postgres and raw devices Stewart Allen <stewart@oec.com>
1994-11-19 20:03 ` Re: Postgres and raw devices Paul M. Aoki <aoki@cs.berkeley.edu>
@ 1994-11-19 22:02 ` Stewart Allen <stewart@oec.com>
0 siblings, 0 replies; 3+ messages in thread
From: Stewart Allen @ 1994-11-19 22:02 UTC (permalink / raw)
To: Paul M. Aoki <aoki@cs.berkeley.edu>; +Cc: legacy
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/
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1994-11-19 22:02 UTC | newest]
Thread overview: 3+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1994-11-19 20:13 Postgres and raw devices Stewart Allen <stewart@oec.com>
1994-11-19 20:03 ` Paul M. Aoki <aoki@cs.berkeley.edu>
1994-11-19 22:02 ` Stewart Allen <stewart@oec.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox