Re: Is pg_control file crashsafe? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Is pg_control file crashsafe?
Date
Msg-id 17675.1462231062@sss.pgh.pa.us
Whole thread Raw
In response to Re: Is pg_control file crashsafe?  (Alex Ignatov <a.ignatov@postgrespro.ru>)
Responses Re: Is pg_control file crashsafe?  (Alex Ignatov <a.ignatov@postgrespro.ru>)
List pgsql-hackers
Alex Ignatov <a.ignatov@postgrespro.ru> writes:
> I think that rename can help a little bit. At least on some FS it is 
> atomic operation.

Writing a single sector ought to be atomic too.  I'm very skeptical that
it'll be an improvement to just move the risk from one filesystem
operation to another; especially not to one where there's not even a
terribly portable way to request fsync.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: [BUGS] Breakage with VACUUM ANALYSE + partitions
Next
From: Andres Freund
Date:
Subject: Re: Is pg_control file crashsafe?