Surafel Temesgen <surafel3...@gmail.com> writes: > According to the documentation –inserts option is mainly useful for making > dumps that can be loaded into non-PostgreSQL databases and to reduce the > amount of rows that might lost during error in reloading but multi values > insert command are equally portable and compact and also faster to reload > than single row statement. I think it deserve an option of its own
I don't actually see the point of this. If you want dump/reload speed you should be using COPY. If that isn't your first priority, it's unlikely that using an option like this would be a good idea. It makes the effects of a bad row much harder to predict, and it increases your odds of OOM problems with wide rows substantially. I grant that COPY might not be an option if you're trying to transfer data to a different DBMS, but the other problems seem likely to apply anywhere. The bad-data hazard, in particular, is probably a much larger concern than it is for Postgres-to-Postgres transfers. regards, tom lane