Re: Load distributed checkpoint

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Load distributed checkpoint
Дата
Msg-id 17799.1167428604@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Load distributed checkpoint  ("Jim C. Nasby" <jim@nasby.net>)
Ответы Re: Load distributed checkpoint  (Bruce Momjian <bruce@momjian.us>)
Re: Load distributed checkpoint  ("Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>)
Список pgsql-hackers
"Jim C. Nasby" <jim@nasby.net> writes:
> I believe there's something similar for OS X as well. The question is:
> would it be better to do that, or to just delay calling fsync until the
> OS has had a chance to write things out.

A delay is not going to help unless you can suppress additional writes
to the file, which I don't think you can unless there's very little
going on in the database --- dirty buffers have to get written to make
room for other pages, checkpoint in progress or no.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Dead Space Map for vacuum
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: effective_cache_size vs units