On Sun, Aug 5, 2018 at 5:29 AM, Mai Peng <maily.peng@xxxxxxxxxxxxxxxxx> wrote:
Hi all,
After the migration to pg 10 by pg_upgrade and vacuumdb, I’ve seen the number of live tuple double and performance decreases on few queries.
Where do these live tuples coming from ?
Thank you
The value stored in n_liv_tup is the value seen when the last analyze was run on the table. It is not kept up to date on every row change and only changes when an analyze is run again. So perhaps the tables you're referencing hadn't been analyzed for a while before you upgraded?
Keith
