Re: END_OF_RECOVERY shutdowns and ResetUnloggedRelations()

Поиск
Список
Период
Сортировка
Искать
От
Abhijit Menon-Sen
Тема
Re: END_OF_RECOVERY shutdowns and ResetUnloggedRelations()
Дата
Msg-id
20140925210406.GA23928@toroid.org
Ответ на
Список
Дерево обсуждения
END_OF_RECOVERY shutdowns and ResetUnloggedRelations() Andres Freund <andres@2ndquadrant.com>
Re: END_OF_RECOVERY shutdowns and ResetUnloggedRelations() Andres Freund <andres@2ndquadrant.com>
Re: END_OF_RECOVERY shutdowns and ResetUnloggedRelations() Robert Haas <robertmhaas@gmail.com>
Re: END_OF_RECOVERY shutdowns and ResetUnloggedRelations() Andres Freund <andres@2ndquadrant.com>
Re: END_OF_RECOVERY shutdowns and ResetUnloggedRelations() Abhijit Menon-Sen <ams@2ndQuadrant.com>
Re: END_OF_RECOVERY shutdowns and ResetUnloggedRelations() Andres Freund <andres@2ndquadrant.com>
Re: END_OF_RECOVERY shutdowns and ResetUnloggedRelations() Abhijit Menon-Sen <ams@2ndQuadrant.com>
Re: END_OF_RECOVERY shutdowns and ResetUnloggedRelations() Andres Freund <andres@2ndquadrant.com>
Re: END_OF_RECOVERY shutdowns and ResetUnloggedRelations() Abhijit Menon-Sen <ams@2ndQuadrant.com>
Re: END_OF_RECOVERY shutdowns and ResetUnloggedRelations() Andres Freund <andres@2ndquadrant.com>
Re: END_OF_RECOVERY shutdowns and ResetUnloggedRelations() Robert Haas <robertmhaas@gmail.com>
At 2014-09-25 22:41:18 +0200, andres@2ndquadrant.com wrote:
>
>  * Also recovery shouldn't be regarded successful if the reset fails -
>  * e.g. because of ENOSPC.

OK.

> * Doing this in a separate pass is advantageous for performance reasons
> * because it allows the kernel to perform all the flushes at once.

OK.

> Unless I miss something this isn't sufficient. We need to fsync the
> files in the data directory, not just the toplevel directory?

No, of course you're right. So a separate function that does the moral
equivalent of "find $PGDATA -exec fsync_fname …"?

Will resubmit with the additional comments.

-- Abhijit


В списке pgsql-hackers по дате отправления
От: Peter Geoghegan
Дата:
От: Simon Riggs
Дата:
FAQ