Thread: pgsql-server/src/bin/pg_dump pg_dump.c

pgsql-server/src/bin/pg_dump pg_dump.c

From
tgl@svr1.postgresql.org (Tom Lane)
Date:
CVSROOT:    /cvsroot
Module name:    pgsql-server
Changes by:    tgl@svr1.postgresql.org    04/03/20 16:09:45

Modified files:
    src/bin/pg_dump: pg_dump.c

Log message:
    Rewrite pg_dump's comment-dumping code to pull over all the comments
    in one query, rather than making a separate query for each object that
    could have a comment.  This costs relatively little space (a few tens of
    K typically) and saves substantial time in databases with many objects.
    I find it reduces the runtime of 'pg_dump -s regression' by about a
    third.