Re: [PERFORM] PostgreSQL Reliability when fsync = false on Linux-XFS

["scott.marlowe" <scott.marlowe@xxxxxxx>]

On Thu, 4 Sep 2003, Federico Sevilla III wrote:

> (Please follow Mail-Followup-To, I'm not on the pgsql-performance
> mailing list but am on the Linux-XFS mailing list. My apologies too for
> the cross-post. I'm cc'ing the Linux-XFS mailing list in case people
> there will be interested in this, too.)
> 
> 
> Hi,
> 
> We have a server running PostgreSQL v7.3.3 on Debian GNU/Linux with
> Linux kernel 2.4.21-xfs. The PostgreSQL data is stored on an XFS[1]

Two points.

1:  7.3.3 has a data loss issue fixed in 7.3.4.  You should upgrade to 
avoid the pain associated with this problem.

2:  When you turn off fsync, all bets are off.  If the data doesn't get 
written in the right order, your database may be corrupted if power is 
shut off.