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
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?
Pandora
yeyu...@qq.com
-- --
??: "Thomas Munro"https://www.postgresql.org/message-i
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
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?