Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

You don't need to turn off synchronous mode, but you can set it to NORMAL, which will only fsync when compacting the WAL file.

Another great pattern for batch writes is to use a system like Nagle's algorithm - push stuff into a queue, and insert from the queue in batches.



Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: