n_live_tup number double after migration do PG 10.4

From: Mai Peng <maily(dot)peng(at)webedia-group(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: n_live_tup number double after migration do PG 10.4
Date: 2018-08-05 09:29:28
Message-ID: ED28CE05-4A54-42D5-84D3-35B4C84BA540@webedia-group.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message legrand legrand 2018-08-05 20:16:37 Re: PostgreSQL 11 global index
Previous Message Mariel Cherkassky 2018-08-05 08:58:37 PostgreSQL 11 global index