| From: | Greg Stark <gsstark(at)mit(dot)edu> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Neil Conway <neilc(at)samurai(dot)com>, Magnus Hagander <mha(at)sollentuna(dot)net>, "Vig, Sandor (G/FI-2)" <Sandor(dot)Vig(at)audi(dot)hu>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL is extremely slow on Windows |
| Date: | 2005-02-25 05:02:25 |
| Message-ID: | 87ekf5qljy.fsf@stark.xeocode.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Right now with fsync off you can get transactions partially commited in your
> database, which is a serious problem (think moving money from one account to
> another).
It's worse than that. You can get a totally corrupted database. Things like
duplicated records (the before and after image of an update). Or indexes that
are out of sync with the table. This can cause strange inconsistent results
depending on the plan queries use, or outright database crashes.
--
greg
| From | Date | Subject | |
|---|---|---|---|
| Next Message | SpaceBallOne | 2005-02-25 07:41:58 | gah! sudden slowdown?? |
| Previous Message | Gaetano Mendola | 2005-02-24 22:30:06 | Re: is pg_autovacuum so effective ? |