Re: Datatypes and performance

On Monday 07 Jul 2003 4:11 pm, Mattias Kregert wrote:
> > > If I turn fsync on and then pull the power cord while a
> > > number of clients are doing lots of inserts/updates and stuff,
> > > will the fsync then guarantee that no data will be lost or
> > > corrupted?
> >
> > You are surely kidding, aren't you ?
> >
> > Karsten
>
> No. No kidding.
> Just to clarify, what I mean is: With FSYNC enabled, after a power failure,
> after "pg_ctl start" and replay of xact log etc; Are COMMITTED transactions
> guaranteed to be intact, and are UNCOMMITTED transactions guaranteed not to
> appear in the tables?
>
> If the answer is "yes", then I understand the use of FSYNC.
>
> If the answer is "no", then i don't see the point in using FSYNC at all.

The answer is "yes" providing:
1. Your hardware didn't suffer a failure during the outage.
2. Your disks don't like to the operating-system.

The second point is important - some disks have write-cache enabled and report
"done" when data is written to the cache not the platter. Google for
discussion.

--
Richard Huxton