On Fri, Jul 29, 2005 at 03:01:07AM -0400, Luke Lonergan wrote:
> I guess we see the real culprit here. Anyone surprised it's the WAL?
So what? Are you planning to suggest people to turn fsync=false?
I just had a person lose 3 days of data on some tables because of that,
even when checkpoints were 5 minutes apart. With fsync off, there's no
work _at all_ going on, not just the WAL -- heap/index file fsync at
checkpoint is also skipped. This is no good.
--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"In a specialized industrial society, it would be a disaster
to have kids running around loose." (Paul Graham)
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
