pg_dump multi VALUES INSERT
Surafel Temsgen <surafel3000@gmail.com>
From: Surafel Temesgen <surafel3000@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2018-10-16T16:17:11Z
Lists: pgsql-hackers
Attachments
- multi_values_inserts_dum_v1.patch (text/x-patch) patch v1
Hello, 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 The patch attached add additional option for multi values insert statement with a default values of 100 row per statement so the row lose during error is at most 100 rather than entire table. Comments? Regards Surafel
Commits
-
Add pg_dumpall --rows-per-insert
- a193cbec1199 12.0 landed
-
pg_dump: allow multiple rows per insert
- 7e413a0f82c8 12.0 landed