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

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB
Тема AW: AW: AW: AW: AW: Vacuum only with 20% old tuples
Дата
Msg-id 11C1E6749A55D411A9670001FA68796336803A@sdexcsrv1.f000.d0188.sd.spardat.at
обсуждение исходный текст
Список pgsql-hackers
> > 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.

I am not sure, but I don't think those are necessary,
only if you want to guarantee no leftover files on backend abort.
I agree that create/delete would be critical to performance.

Andreas


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Loading binary data into the database
Следующее
От: Jeffery Collins
Дата:
Сообщение: Re: [GENERAL] Some questions on user defined types and functions.