Re: [GENERAL] Running with fsync=off - Mailing list pgsql-admin

From Tom Lane
Subject Re: [GENERAL] Running with fsync=off
Date
Msg-id 21388.1135799920@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] Running with fsync=off  ("Qingqing Zhou" <zhouqq@cs.toronto.edu>)
List pgsql-admin
"Qingqing Zhou" <zhouqq@cs.toronto.edu> writes:
> But in our 7.4.x, there is code like this:

>  sync();
>  if (IsUnderPostmaster)
>   sleep(2);
>  sync();

I'm not claiming that that code is correct; it is in fact just as broken
as the traditional custom.  You'll notice we don't have it anymore ;-)

> Why wasting 2 seconds is enough to save the data?

It's not.  The entire custom is and always has been bogus.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Qingqing Zhou"
Date:
Subject: Re: [GENERAL] Running with fsync=off
Next
From: Bruno Wolff III
Date:
Subject: Re: preventing deadlocks