Re: END_OF_RECOVERY shutdowns and ResetUnloggedRelations() - Mailing list pgsql-hackers

From Abhijit Menon-Sen
Subject Re: END_OF_RECOVERY shutdowns and ResetUnloggedRelations()
Date
Msg-id 20140925210406.GA23928@toroid.org
Whole thread Raw
In response to Re: END_OF_RECOVERY shutdowns and ResetUnloggedRelations()  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: END_OF_RECOVERY shutdowns and ResetUnloggedRelations()  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
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 by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}
Next
From: Simon Riggs
Date:
Subject: Re: Immediate standby promotion