3 ms·
Was it unusable because cpu/io was maxed out during ANALYZE?
by zonkd1234 2y ago
Was it unusable because cpu/io was maxed out during ANALYZE?
- pilif 2y agoAnalyze itself isn’t the problem. After pg_upgrade, no stats will be available for the optimizer which means that any query will more or less sequence-scan all affected tables.
- timacles 2y agoNo, its the lack of stats on the tables, any query hitting a medium to large table would be extremely slow.