On Tue, Dec 5, 2017 at 09:30:53AM -0500, Stephen Frost wrote: > > > The other concern is if there's changes made to the catalogs by non-DDL > > > activity that needs to be addressed too (logical replication?); nothing > > > definite springs to mind off-hand for me, but perhaps others will think > > > of things. > > > > Yes, it could extend to many parts of the system, which is why I am > > asking if it is worth it. > > My initial reaction is that it's worth it, but then I also wonder about > other issues (having to get an ANALYZE done on the new cluster before > opening it up, for example..) and it makes me wonder if perhaps it'll > end up being too much risk for too little gain.
Yes, dump/reload of analyze statistics seems like a better use of time. I have avoided it since it locks us into supporting the text respresentation of data type, but at this point it might be worth it. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +
