fsync and hardware write cache

From: pgsql(at)mohawksoft(dot)com
To: pgsql-hackers(at)postgresql(dot)org
Subject: fsync and hardware write cache
Date: 2004-08-23 18:34:32
Message-ID: 37593.64.119.142.34.1093286072.squirrel@mail.mohawksoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Something to think about:

if you run PostgreSQL with fsync on, but you use the hardware write cache
on your disk drives, how likely are you to lose data? Obviously, this is a
fairly limited problem, as it only applies to power down (which you can
control) or power loss where the risks may be reduced but not eliminated
with a UPS.

Does it make sense to add a platform specific call that will flush a write
cache when fsync is enable?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-08-23 18:46:17 Re: missing data/global
Previous Message Bruce Momjian 2004-08-23 18:28:42 Re: fsync and hardware write cache