The trick is to do things like this in less bigger transactions. One huge may be too much. Especially if the logfile you want to import gets bigger. I'm surprised you did not find any references to this, batching inserts is an "old vest". How big to make the transactions is something you usually have to find out by testing.