Chris Angelico wrote:
>> - Set fsync=off and hope you don't crash.
>
> Ouch. I might consider that for a bulk import operation or something,
> but not for live usage. There's plenty else can be done without
> risking data corruption.
I didn't mean that to be an alternative that anybody should
consider for production use.
I don't think that there are so many ways to speed up
INSERTs. Can you think of some that I have missed?
Yours,
Laurenz Albe