Re: [GENERAL] Running with fsync=off

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: Martijn van Oosterhout <kleptog(at)svana(dot)org>, Benjamin Arai <barai(at)cs(dot)ucr(dot)edu>, pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Running with fsync=off
Date: 2005-12-27 22:44:10
Message-ID: 4550.1135723450@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

"Jim C. Nasby" <jnasby(at)pervasive(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Aftab Alam 2005-12-28 03:37:52 Re: sending mail from Postgres
Previous Message Jim C. Nasby 2005-12-27 21:39:37 Re: Pgstat.tmp file activity

Browse pgsql-general by date

  From Date Subject
Next Message Petr 2005-12-27 23:39:53 Detaching database
Previous Message Tom Lane 2005-12-27 22:36:28 Re: EXPLAIN ANALYZE output