Are you inserting from multiple sources or a single source? If from a single source then what you are complaining from is syncing on every insert, which is not that related to locking. If you are inserting for multiple sources then locking will be an issue of course. May be you want to consider WAL mode with synchronous set to "Normal" but check if the durability guarantees fit your application requirements