Your SSD lies but that's ok | Postgres fsync
The Backend Engineering Show with Hussein Nasser
00:00
The Power of Order
Writing directly to the disk without utilizing page cache can provide speed advantages but also exposes the system to potential corruption risks if not managed well. Postgres offers options like enabling fsync to delay wall writing until committing the transactions, ensuring data is committed accurately. Additionally, the ability to issue if sync only at the commit stage enhances performance by efficiently managing transaction writes in memory before flushing to disk. Another option is if data sync, which flushes data entries upon committing transactions but not the metadata. Postgres also allows turning off fsync for wall writing if needed.
Transcript
Play full episode
Remember Everything You Learn from Podcasts
Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.
