Asynchronous commit

Posted Mar 27, 2014 16:36 UTC (Thu) by zblaxell (subscriber, #26385)
In reply to: Asynchronous commit by marcH
Parent article: PostgreSQL pain points

I thought I covered that as undesirable option #3 ("put the filesystem in a database server that implements asynchronous commit"). ;)

The RDBMS state of the art has progressed over the last 20 years, providing a wide variety of reasonable data integrity and performance tradeoffs. It would be nice if filesystems could catch up. fsync() is a sledgehammer.