On Wed, Jul 19, 2023 at 2:09 PM Pandora wrote:
> Yes, I saw the usage of syncfs in PG14, but it is recommended to use it on
> Linux 5.8 or higher. If my OS version is lower than 5.8, can I still enable
> it?
Nothing stops you from enabling it, it's fairly ancient and should
work. It just doesn
On Wed, Jul 19, 2023 at 12:41 PM Michael Paquier wrote:
> On Tue, Jul 18, 2023 at 04:50:25PM +0800, Pandora wrote:
> > I found that starting from version 9.5, PostgreSQL will do fsync on
> > the entire data directory after DB crash. Here's a question: if I
> > have FPW = on, why is this step still
On Tue, Jul 18, 2023 at 04:50:25PM +0800, Pandora wrote:
> I found that starting from version 9.5, PostgreSQL will do fsync on
> the entire data directory after DB crash. Here's a question: if I
> have FPW = on, why is this step still necessary?
Yes, see around the call of SyncDataDirectory() in x
