Re: [GENERAL] Running with fsync=off

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [GENERAL] Running with fsync=off
Date: 2005-12-28 19:58:40
Message-ID: 21388.1135799920@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

"Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bruno Wolff III 2005-12-28 20:26:07 Re: preventing deadlocks
Previous Message Qingqing Zhou 2005-12-28 19:12:54 Re: [GENERAL] Running with fsync=off

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-12-28 20:02:07 Re: C Function Problem for bytea output
Previous Message John McCawley 2005-12-28 19:47:12 Queries never returning...