logoalt Hacker News

glimshe • today at 10:53 AM • 1 reply • view on HN

But no database that ensures ACID can avoid that one.

If that's the problem, we should say "Postgres isn't slow, you're just on ACID".


Replies

sausagefeet • today at 11:05 AM

Is that entirely true? If you have a replication protocol like Viewstamped Replication you have the option to make a trade off for how many machines you the will fail concurrently vs forcing an fsync.

I think I'm a bit of an outlier here on that k never really understood why durability requires fsync. It doesn't help you if the storage dies. If durable storage is important to you, then isn't the only solution to synchronously replicate to a quorum of machines at which point an fsync isn't that relevant? What am I missing?

➕ show 2 replies