Re: RE: xlog checkpoint depends on sync() ... seems uns afe

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: RE: xlog checkpoint depends on sync() ... seems uns afe
Дата
Msg-id m3ofv6jkbh.fsf@belphigor.mcnaught.org
обсуждение исходный текст
Ответ на RE: RE: xlog checkpoint depends on sync() ... seems uns afe  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
Список pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:

> "Mikheev, Vadim" <vmikheev@SECTORBASE.COM> writes:
> >> The idea is, that by the time the last sync has run, the 
> >> first sync will be done flushing the buffers to disk. - this is what
> >> we were told by the IBM engineers when I worked tier-2/3 AIX support
> >> at IBM.
> 
> > I was told the same a long ago about FreeBSD. How much can we count on
> > this undocumented sync() feature?
> 
> Sounds quite unreliable to me.  Unless there's some interlock ... like,
> say, the second sync not being able to advance past a buffer page that's
> as yet unwritten by the first sync.  But would all Unixen share such a
> strange detail of implementation?

I'm pretty sure it has no basis in fact, it's just one of these habits 
that gives sysadmins a warm fuzzy feeling.  ;)  It's apparently been
around a long time, though I don't remember where I read about it--it
was quite a few years ago.

-Doug



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

Предыдущее
От: "Mikheev, Vadim"
Дата:
Сообщение: RE: xlog loose ends, continued
Следующее
От: Giles Lean
Дата:
Сообщение: Re: RE: xlog checkpoint depends on sync() ... seems uns afe