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

From Tom Lane
Subject Re: [GENERAL] Running with fsync=off
Date
Msg-id 4550.1135723450@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] Running with fsync=off  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-admin
"Jim C. Nasby" <jnasby@pervasive.com> writes:
> How would sync<RETURN>sync<RETURN> differ from sync;sync? The second
> case will wait for the first command to return, or is there a race
> condition that's reduced by typing by hand?

The actual runtime of the "sync" program is epsilon, because it doesn't
wait for all the I/O to happen.  The entire reason for the custom is
that the I/O is going on while you type the second "sync".  And yes,
it's a race condition.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Pgstat.tmp file activity
Next
From: "Aftab Alam"
Date:
Subject: Re: sending mail from Postgres