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. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org