I'm currently obsessing over bulk inserts via prepared statements with libpqxx.
I am far from a database expert and even further when it comes to Postgres, but just thinking superficially, it doesn't seem like it would make a difference.
In my MySQL days, it made a huge difference, but it strikes me that MySQL's clustered index was the bottleneck, that it would be better to prepare it for many rows at once rather than one at a time.
Since Postgres doesn't do that, happily I might add, is it correct that there would be a near negligible performance boost to bulk inserts? Please explain why or why not.