Re: fsync or fdatasync

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: fsync or fdatasync
Дата
Msg-id 200209101717.g8AHHuV29296@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: fsync or fdatasync  (Ragnar Kjørstad <postgres@ragnark.vestdata.no>)
Ответы Re: fsync or fdatasync
Список pgsql-admin
Ragnar Kj�rstad wrote:
> On Tue, Sep 10, 2002 at 11:40:24AM -0400, Bruce Momjian wrote:
> >
> > The original poster was wrong about the default.
> >
> > We use fdatasync where available, and fsync when it is not.
>
> Makes sense.
>
> > We also use
> > O_SYNC on open if it is available.
>
> Why? That will slow tings down...

Actually, no, we are only O_SYNC'ing the WAL writes and sometimes that
is faster because you are not writing then fsyncing, you are just
writing.  The fdatasync only is better than O_SYNC when you are doing
multiple WAL writes before an fdatasync and we normally don't do that.

--
  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-admin по дате отправления:

Предыдущее
От: Jodi Kanter
Дата:
Сообщение: Fw: consulta
Следующее
От: Ragnar Kjørstad
Дата:
Сообщение: Re: fsync or fdatasync