AW: [HACKERS] RAW I/O device

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB
Тема AW: [HACKERS] RAW I/O device
Дата
Msg-id 219F68D65015D011A8E000006F8590C603FDC1B0@sdexcsrv1.f000.d0188.sd.spardat.at
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: jose soares
Дата:
Сообщение: Re: [HACKERS] TRANSACTION "WARNINGS"
Следующее
От: Zeugswetter Andreas SB
Дата:
Сообщение: AW: [HACKERS] RAW I/O device