]> granicus.if.org Git - postgresql/commit
Speed up printing of INSERT statements in pg_dump.
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 15 Nov 2013 23:02:06 +0000 (18:02 -0500)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 15 Nov 2013 23:02:06 +0000 (18:02 -0500)
commit97e1ec467099f1e581f491c8a57b7d56d0b9c539
tree23ccc748b4fb63af797dd901777fc5fe697ae958
parent3172eea062e779db39df9a48fca0ad7448163f98
Speed up printing of INSERT statements in pg_dump.

In --inserts and especially --column-inserts mode, we can get a useful
speedup by generating the common prefix of all a table's INSERT commands
just once, and then printing the prebuilt string for each row.  This avoids
multiple invocations of fmtId() and other minor fooling around.

David Rowley
src/bin/pg_dump/pg_dump.c