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

From Zeugswetter Andreas SB
Subject AW: [HACKERS] RAW I/O device
Date
Msg-id 219F68D65015D011A8E000006F8590C603FDC1B0@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
List pgsql-hackers
> > Actually, Oracle has been moving *away* from this...more 
> recent versions
> > of Oracle recommend using the Operating System file 
> systems, since, in

This is untrue. They need the raw devices for their big DB's
(Parallel Server)

> > most cases, the Operating System does a better job, and its 
> too difficult
> > to have Oracle itself optimize internal for all the 

This is especially true for Oracle, since the don't have very 
intelligent IO optimizations.

Good DB sided IO optimization can outperform any OS easily.
Especially once you reach the RAM limits of your system.
write cache, read ahead, indexed read ahead, 
increased block size (up to 256k) .....

> different variants
> > that it supports....

There is not really that much difference.

Andreas


pgsql-hackers by date:

Previous
From: jose soares
Date:
Subject: Re: [HACKERS] TRANSACTION "WARNINGS"
Next
From: Zeugswetter Andreas SB
Date:
Subject: AW: [HACKERS] RAW I/O device