n_live_tup number double after migration do PG 10.4

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "pgsql-admin@xxxxxxxxxxxxxx" <pgsql-admin@xxxxxxxxxxxxxx>
Subject: n_live_tup number double after migration do PG 10.4
From: Mai Peng <maily.peng@xxxxxxxxxxxxxxxxx>
Date: Sun, 5 Aug 2018 11:29:28 +0200

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

Follow-Ups:
- Re: n_live_tup number double after migration do PG 10.4
  - From: Keith

Prev by Date: PostgreSQL 11 global index
Next by Date: Re: PostgreSQL 11 global index
Previous by thread: PostgreSQL 11 global index
Next by thread: Re: n_live_tup number double after migration do PG 10.4
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux