[ On Friday, June 21, 2002 at 18:00:19 (-0300), Martín Marqués wrote: ]
> Subject: Re: Backing up PostgreSQL?
>
> On Vie 21 Jun 2002 17:33, Greg A. Woods wrote:
> > [ On Friday, June 21, 2002 at 18:37:20 (+0100), Paul Jakma wrote: ]
> >
> > > Subject: Re: Backing up PostgreSQL?
> > >
> > > On Thu, 20 Jun 2002, Greg A. Woods wrote:
> > > > > Where does it say that close/open will flush metadata?
> > > >
> > > > That's how the unix filesystem works. UTSL.
> > >
> > > that's an implementation issue - you cant rely on it.
> >
> > Apparently you can on anything but linux, and I'm rather stunned by the
> > situation with the latter....
>
> Other UNIX? If you could rely on it, why does Informix (and other database
> servers, but this is the one I used) still use it's own FS to write the
> database files?
Because there are tremendous performance advantages to using RAW I/O if
you're prepared to go to the trouble of dealing with all the niggling
details....
(some of these advantages are supposedly less visible on modern hardware
and modern systems, but they sure as heck were plainly visible even a
few years ago)
--
Greg A. Woods
+1 416 218-0098; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Planix, Inc. <[EMAIL PROTECTED]>; VE3TCP; Secrets of the Weird <[EMAIL PROTECTED]>
