Forcing analyze on DB after upgrading?
Wells Oliver <[email protected]> Tue, 29 Oct 2019 22:11:51 -0700
| Newsgroups | gmane.comp.db.postgresql.admin |
|---|---|
| Message-ID | <CAOC+FBUsOAKGBdNVmr2OSiRq7nLw=5jWMRjd9C5AWT6TVLXU-A@mail.gmail.com> |
I just upgraded from 9.6 to 12, and am noticing some queries are slow. I did this kind of query: SELECT relname, last_vacuum, last_autovacuum, last_analyze, last_autoanalyze FROM pg_stat_all_tables WHERE schemaname = 'myschema'; And noticed null values for everything, including last analyze date. Does this mean the planner won't be able to optimize for these tables? Do I need to do something to prep my DB for planning after upgrade? -- Wells Oliver [email protected] <[email protected]>