Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL is extremely slow on Windows

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 (view raw or flat)
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


In response to

pgsql-performance by date

Next:From: SpaceBallOneDate: 2005-02-25 07:41:58
Subject: gah! sudden slowdown??
Previous:From: Gaetano MendolaDate: 2005-02-24 22:30:06
Subject: Re: is pg_autovacuum so effective ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group