| From: | Abhijit Menon-Sen <ams(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)2ndquadrant(dot)com> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: END_OF_RECOVERY shutdowns and ResetUnloggedRelations() |
| Date: | 2014-09-24 11:36:05 |
| Message-ID: | 20140924113605.GA20227@toroid.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi Andres, Robert.
I've attached four patches here.
1. Move the call to ResetUnloggedRelations(UNLOGGED_RELATION_INIT) to
earlier in StartupXLOG.
2. Inside that function, issue fsync()s for the main forks we create by
copying the _init fork.
3. A small fixup to add a const to "typedef char *FileName", because the
earlier patch gave me warnings about discarding const-ness. This is
consistent with many other functions in fd.c that take const char *.
4. Issue an fsync() on the data directory at startup if we need to
perform crash recovery.
I created some unlogged relations, performed an immediate shutdown, and
then straced postgres as it performed crash recovery. The changes in (2)
do indeed fsync the files we create by copying *_init, and don't fsync
anything else (at least not after I fixed a bug ;-).
I did not do anything about the END_OF_RECOVERY checkpoint setting the
ControlFile->state to DB_SHUTDOWNED, because it wasn't clear to me if
there was any agreement on what to do. I would be happy to submit a
followup patch if we reach some decision about it.
Is this what you had in mind?
-- Abhijit
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-Call-ResetUnloggedRelations-UNLOGGED_RELATION_INIT-e.patch | text/x-diff | 1.9 KB |
| 0002-Make-ResetUnloggedRelations-_INIT-fsync-newly-create.patch | text/x-diff | 2.1 KB |
| 0003-Add-const-to-FileName-typedef-make-fsync_fname-use-i.patch | text/x-diff | 1.7 KB |
| 0004-If-we-need-to-perform-crash-recovery-fsync-the-data-.patch | text/x-diff | 1.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2014-09-24 11:44:56 | Re: make pg_controldata accept "-D dirname" |
| Previous Message | Abhijit Menon-Sen | 2014-09-24 11:21:03 | Re: make pg_controldata accept "-D dirname" |