Horton

Change pg_dump default for statistics export.

Jeff Davis <jdavis@postgresql.org>

View on postgr.es
Commit: 34eb2a80d5a3ea1392e4a9f16ebac54e96d0c6ed
Author: Jeff Davis <jdavis@postgresql.org>
Date: 2025-05-27T20:54:38Z
Releases: 18.0 
Change pg_dump default for statistics export.

Set the default behavior of pg_dump and pg_dumpall to be
--no-statistics.

Leave the default for pg_restore and pg_upgrade to be
--with-statistics.

Discussion: https://postgr.es/m/CA+TgmoZ9=RnWcCOZiKYYjZs_AW1P4QXCw--h4dOLLHuf1Omung@mail.gmail.com
Reviewed-by: Greg Sabino Mullane <htamfids@gmail.com>
Reviewed-by: Nathan Bossart <nathandbossart@gmail.com>
Reviewed-by: Robert Haas <robertmhaas@gmail.com>
Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us>

Files

PathChange+/−
doc/src/sgml/ref/pg_dumpall.sgml modified +10 −10
doc/src/sgml/ref/pg_dump.sgml modified +10 −10
src/bin/pg_dump/pg_backup_archiver.c modified +1 −1
src/bin/pg_dump/t/002_pg_dump.pl modified +59 −0
src/bin/pg_upgrade/dump.c modified +1 −1

Documentation touched

Discussion