Re: AW: AW: AW: AW: Vacuum only with 20% old tuples

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: AW: AW: AW: AW: Vacuum only with 20% old tuples
Дата
Msg-id 7982.964706622@sss.pgh.pa.us
обсуждение исходный текст
Ответ на AW: AW: AW: AW: Vacuum only with 20% old tuples  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
Список pgsql-hackers
Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at> writes:
> But yes the rename log entries (only those) would need to be 
> written immediately. Is this a performance issue? I guess not.

Two fsyncs per rename is probably not a performance killer, but you'd
have to also fsync log entries for file creates and deletes, which
might be a bigger deal.
        regards, tom lane


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

Предыдущее
От: frank
Дата:
Сообщение: Re: Is Pg 7.0.x's Locking Mechanism BROKEN?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Loading binary data into the database