Re: [HACKERS] RAW I/O device - Mailing list pgsql-hackers

From The Hermit Hacker
Subject Re: [HACKERS] RAW I/O device
Date
Msg-id Pine.BSF.4.21.9912061041290.18029-100000@thelab.hub.org
Whole thread Raw
In response to Re: [HACKERS] RAW I/O device  ("Ing. Pavel PaJaSoft Janousek" <pajasoft@fonet.cz>)
Responses Re: [HACKERS] RAW I/O device
Re: view dying out of the blue...
Re: [HACKERS] RAW I/O device
List pgsql-hackers
On Mon, 6 Dec 1999, Ing. Pavel PaJaSoft Janousek wrote:

> > other systems besides linux.  Making the DB work w/ one FS (and write the
> > storage code for it) seems pointless if we are still stuck on normal FSs
> > on other machines.
> 
>     Yes, of course, but storing databases directly to RAW device - not
> through the filesystem - is one feature of modern DB engines...

Actually, Oracle has been moving *away* from this...more recent versions
of Oracle recommend using the Operating System file systems, since, in
most cases, the Operating System does a better job, and its too difficult
to have Oracle itself optimize internal for all the different variants
that it supports....

At work, we use Oracle extensively, and I sat down one day last year with
our Oracle DBA to discuss exactly this...and, if I recall correctly, it
was prompted by a similar thread here...

If Linux is providing an Interface into the RAW file system, then this may
change things for Oracle, since it wouldn't have to "learn" all the
different OSs, as long as the API is the same across them all...and, my
experience with Linux is that the API for Linux will most likely be
different then everyone else *roll eyes*

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] When is 7.0 going Beta?
Next
From: Tom Lane
Date:
Subject: Binary-compatible type follies