Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> On Thu, 2006-04-27 at 16:31 +1000, Guoping Zhang wrote:
>> Can we set fsync OFF for the performance benefit, have the risk of only 5
>> minutes data loss or much worse?
> Thats up to you.
> fsync can be turned on and off, so you can make critical changes with
> fsync on, then continue with fsync off.
I think it would be a mistake to assume that the behavior would be
nice clean "we only lost recent changes". Things could get arbitrarily
badly corrupted if some writes make it to disk and some don't.
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Vivek Khera||Date: 2006-04-27 15:11:42|
|Subject: Re: Large (8M) cache vs. dual-core CPUs|
|Previous:||From: Tom Lane||Date: 2006-04-27 14:53:28|
|Subject: Re: how unsafe (or worst scenarios) when setting fsync OFF for postgresql |