Stats Disappear After Minor Upgrade?

From: Don Seiler <don(at)seiler(dot)us>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Stats Disappear After Minor Upgrade?
Date: 2017-08-15 21:49:29
Message-ID: CAHJZqBAQNLK1xa3pRqr9f7qUCaHqKJ9r_4Ymu1J_jSTQQw26iA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Me again.

I'm testing an upgrade of a database from 9.2.10 to 9.2.22. The upgrade
seemingly had no problems and I started the DB. However when I went to look
at some vacuum-related status, every table had n_dead_tup and n_live_tup =
0.

For what it's worth, this DB was a clone of a prod standby. I didn't think
to check the stats after opening the new clone (renamed the recovery.conf),
so I can't say for sure what it looked like prior to upgrade. I've kicked
off a DB-wide analyze but obviously that takes a long time and more or less
would mean prod app downtime as the optimizer would make all sorts of goofy
decisions until the stats are in place.

I just wanted to ask here if anything like this is known. I know 10->22 is
a bit of a leap but it's still the same major branch so I didn't expect any
trouble. My other tests in small sandboxes were from 9.2.18 or .21 to
9.2.22 and had no problems like this.

Don.

--
Don Seiler
www.seiler.us

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2017-08-15 22:50:55 Re: Stats Disappear After Minor Upgrade?
Previous Message Jerry Sievers 2017-08-15 19:50:12 Re: CREATE ANY TABLE privileges, etc