| From: | "Mattias Kregert" <mattias(at)kregert(dot)se> |
|---|---|
| To: | "Karsten Hilbert" <Karsten(dot)Hilbert(at)gmx(dot)net>, "PostgreSQL List" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Datatypes and performance |
| Date: | 2003-07-07 15:11:45 |
| Message-ID: | 018c01c3449a$414e2ac0$09000a0a@kregert.se |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> > 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.
/* m */
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Maksim Likharev | 2003-07-07 15:37:54 | Re: Datatypes and performance |
| Previous Message | Laurent Michel | 2003-07-07 15:10:15 | pg_restore very slow |