On Sun, Aug 5, 2018 at 5:29 AM, Mai Peng <maily(dot)peng(at)webedia-group(dot)com>
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