Postgres Pro
Downloads
Home   >   mailing lists

n_live_tup number double after migration do PG 10.4 - Mailing list pgsql-admin

From Mai Peng
Subject n_live_tup number double after migration do PG 10.4
Date
Msg-id ED28CE05-4A54-42D5-84D3-35B4C84BA540@webedia-group.com
Whole thread Raw
Responses Re: n_live_tup number double after migration do PG 10.4  (Keith <keith@keithf4.com>)
List pgsql-admin
Tree view 
Hi all,

After the migration to pg 10 by pg_upgrade and vacuumdb, I’ve seen the number of live tuple double and performance
decreaseson few queries. 
Where do these live tuples coming from ?

Thank you

pgsql-admin by date:

Previous
From: Mariel Cherkassky
Date:
Subject: PostgreSQL 11 global index
Next
From: legrand legrand
Date:
Subject: Re: PostgreSQL 11 global index