News for hackers. Stuff that matters.
Re:AWS services to avoid by gigatexal on Sunday May 10, 2020 @04:06PM (#23135710)
Former DBA here ... you don't disable fsync.
Re:AWS services to avoid by antirez on Sunday May 10, 2020 @04:16PM (#23135775)
No but often you set it to fsync every second and not at every write, if you are really concerned with performances in certain kind of applications. Or in practical terms, check the synchronous_commit config option of PostgreSQL. Basically sometimes you have fsync enabled because you don't want to corrupt the log, but the writes will not wait for the WAL, so the last transactions can get lost on crash.
Re:AWS services to avoid by gigatexal on Sunday May 10, 2020 @05:21PM (#23136325)
I would just throw more money at the problem not weaken the strength of my confidence in the underlying storage subsystem or the DB by playing with the fsync behaivor willy-nilly nor even in a calculated way. I would instead just throw more money at the problem by investing in faster and faster disks -- you can do a lot with enterprise grade NVMe now.