Re: Creation of an empty table is not fsync'd at checkpoint

Thomas Munro <thomas.munro@gmail.com>

From: Thomas Munro <thomas.munro@gmail.com>

To: Heikki Linnakangas <hlinnaka@iki.fi>

Cc: pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2022-01-27T19:12:54Z

Lists: pgsql-hackers

On Fri, Jan 28, 2022 at 6:55 AM Heikki Linnakangas <hlinnaka@iki.fi> wrote:
> I think the simplest fix is to call register_dirty_segment() from
> mdcreate(). As in the attached. Thoughts?

+1

Commits

Ensure that creation of an empty relfile is fsync'd at checkpoint.
- 6377f705cab2 11.21 landed
- 1b4f1c6f8a6c 12.16 landed
- acc8cdff4245 13.12 landed
- d85bf0719e71 14.9 landed
- e24c02e4d258 15.4 landed
- d431644b43fc 16.0 landed
- 4b4798e1384c 17.0 landed
Fix missing fsync of SLRU directories.
- aca74843e40f 14.0 cited