On Mon, Mar 31, 2025 at 10:33 PM Nathan Bossart <nathandboss...@gmail.com> wrote: > On Mon, Mar 31, 2025 at 11:11:47AM -0400, Corey Huinker wrote: > Regarding whether pg_dump should dump statistics by default, my current > thinking is that it shouldn't, but I think we _should_ have pg_upgrade > dump/restore statistics by default because that is arguably the most > important use-case. This is more a gut feeling than anything, so I reserve > the right to change my opinion. >
I did some mental exercises on a number of different use cases and scenarios (pagila work, pgextractor type stuff, backups, etc...) and I couldn't come up with any strong arguments against including the stats by default, generally because I think when your process needs to care about the output of pg_dump, it seems like most cases require enough specificity that this wouldn't actually break that. Still, I am sympathetic to Greg's earlier concerns on the topic, but would also agree it seems like a clear win for pg_upgrade, so I think our gut feelings might actually be aligned on this one ;-) Robert Treat https://xzilla.net
