From: | Wells Oliver <wells(dot)oliver(at)gmail(dot)com> |
---|---|
To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Forcing analyze on DB after upgrading? |
Date: | 2019-10-30 05:41:34 |
Message-ID: | CAOC+FBXa0PbdmsqgdnT3y8LzYHsDuJ7NY4Z62fETA6cJyS_MfA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thanks! Unfortunately I can't find the shell script it created in
/var/log/postgresql -- however, I ran vacuumdb --full --verbose
--analyze-in-stages and the DB performs much, much better.
As I can't seem to find the script, anything else a good thing to do after
doing pg_upgrade to prime the DB?
On Tue, Oct 29, 2019 at 10:38 PM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:
> On Tue, 2019-10-29 at 22:11 -0700, Wells Oliver wrote:
> > 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?
>
> You used pg_upgrade, right?
> pg_upgrade won't migrate any table statistics.
>
> You'll have to run ANALYZE to collect new ones.
>
> This is even mentioned in the output of pg_upgrade,
> and it writes a convenient shell script that does the
> ANALYZE for you.
>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
>
>
--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2019-10-30 05:48:43 | Re: Forcing analyze on DB after upgrading? |
Previous Message | Laurenz Albe | 2019-10-30 05:38:38 | Re: Forcing analyze on DB after upgrading? |