Re: O_DIRECT option used?

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: O_DIRECT option used?
Дата
Msg-id 200212092134.gB9LYkY16146@candle.pha.pa.us
обсуждение исходный текст
Ответ на O_DIRECT option used?  (Ruslan A Dautkhanov <rusland@scn.ru>)
Список pgsql-bugs
Read the developer's FAQ on advanced features.  We don't think it will
be a big win.

---------------------------------------------------------------------------

Ruslan A Dautkhanov wrote:
>             Hello,
>
>         In the FreeBSD 4.5 appear additional O_DIRECT option for open(2),
>     which mean "eliminate or reduce cache effects". I think, that double
>     buffering the same disk blocks is ineffective. I grepped all
>     PostgreSQL sources for this options and didn't find this anywhere.
>     PgSQL have it's own disk caches, which should be smart
>     (DB can know what data should be cached first better than OS).
>     Why wasting OS memory for double caches? OS can use this caches
>     for other disk blocks, so total cached disk blocks in whole
>     system will be much bigger. If you have no plans to implement this,
>     please let us know what source files I should looking for patching.
>     I think it's somewhere DB tables files are opened (and maybe
>     WAL files too).   Thanks a lot on any comments.
>
>
>
>     ---
>      best regards,
>     Ruslan A Dautkhanov   rusland@scn.ru

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Jean-Luc Lachance
Дата:
Сообщение: Re: [ADMIN] 7.3 RMPS bugs ( pgdb.py and postgresql launch script
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: PostgreSQL 7.3 Installation on SCO