Re: [pgsql-hackers-win32] fsync with sync, and Win32 unlink

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB SD
Тема Re: [pgsql-hackers-win32] fsync with sync, and Win32 unlink
Дата
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA40184D019@m0114.s-mxs.net
обсуждение исходный текст
Ответы Re: [pgsql-hackers-win32] fsync with sync, and Win32 unlink  (Greg Stark <gsstark@mit.edu>)
Список pgsql-hackers
> Consider either a box with many different postgresql instances, or one
> that run both postgresql and other software. Issuing sync() in that
> sitaution will cause sync of a lot of data that probably doesn't need
> syncing.
> But it'd probably be a very good thing on a dedicated server, giving the
> kernel the chance to optimise.

It is not like the sync is done every few seconds ! It is currently done
every 5 minutes (I actually think this is too frequent now that we have
bgwriter, 10 - 20 min would be sufficient). So imho even on a heavily
otherwise used system the sync will be better.

Andreas

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

Предыдущее
От: "Magnus Hagander"
Дата:
Сообщение: Re: [pgsql-hackers-win32] fsync with sync, and Win32 unlink
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: unsafe floats