Re: END_OF_RECOVERY shutdowns and ResetUnloggedRelations()
От
Abhijit Menon-Sen
Тема
Re: END_OF_RECOVERY shutdowns and ResetUnloggedRelations()
Дата
Msg-id
20140925210406.GA23928@toroid.org
Ответ на
Re: END_OF_RECOVERY shutdowns and ResetUnloggedRelations() (Andres Freund)
Список
Дерево обсуждения
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 по дате отправления