Internal pointers clobbered on system crash without fsync???

From: "earthlink" <NOSPAMnews(at)tinyvital(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Internal pointers clobbered on system crash without fsync???
Date: 2001-06-08 16:48:01
Message-ID: 5l7U6.2730$p%4.249060@newsread2.prod.itd.earthlink.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

If one runs Postgresql with fsync turned off in order to get better
performance, is there a risk that the database internals will be
damaged by a system crash? I realize that database discrepancies are
possible, but I am referring to a failure where storage allocation
gets messed up, or critical internal pointers get mangled, or
something like that.

What I have been able to find so far only addresses data
discrepancies, which are something that we can live with (IF WE REALLY
HAVE TO).

Also, if one uses raw disk instead of files, will Postgresql work
better with or without fsync?

For that matter, how does Postgresql with fsync turned on compare
performance/wise to Informix/Oracle for typical OLTP (95% read 5%
write) work?

Thanks in advance

John Moore

newsNOSPAM(at)tinyvital(dot)com

Browse pgsql-hackers by date

  From Date Subject
Next Message earthlink 2001-06-08 16:49:13 Implicit order-by in Postgresql?
Previous Message Thomas Lockhart 2001-06-08 16:27:37 Re: AW: Re: [SQL] behavior of ' = NULL' vs. MySQL vs. Stand ards