Re: Copy Statistics Tables During Upgrade

2021-04-02 Thread Pierre Forstmann
Hello, This is a pg_upgrade known limitation that has been summarized by Greg Sabino Mullane on https://www.endpoint.com/blog/2016/12/07/postgres-statistics-and-pain-of-analyze this way: The nominal reason for not copying the data is that the table format may change from version to version.

Copy Statistics Tables During Upgrade

2021-03-31 Thread Virendra Kumar
Hello Team, I was doing an upgrade of one of our PG (9.6.11 to 11.9) database and came across the question that what is reason PostgreSQL is not doing copy of stats and we have to analyze right after upgrade. There are two situations where this will help when we use this DB as our enterprise dat