On Fri, 2024-03-29 at 18:02 -0400, Stephen Frost wrote: > I’d certainly think “with stats” would be the preferred default of > our users.
I'm concerned there could still be paths that lead to an error. For pg_restore, or when loading a SQL file, a single error isn't fatal (unless -e is specified), but it still could be somewhat scary to see errors during a reload. Also, it's new behavior, so it may cause some minor surprises, or there might be minor interactions to work out. For instance, dumping stats doesn't make a lot of sense if pg_upgrade (or something else) is just going to run analyze anyway. What do you think about starting off with it as non-default, and then switching it to default in 18? Regards, Jeff Davis