Re: vacuum curiosity

2017-12-17 Thread Melvin Davidson
>Does that suggest there is an open transaction? No, it simply means there are zero/no dead rows that can be removed at that time. Please refer to the documentation on VACUUM, specifically 24.1.2. Recovering Disk Space https://w

vacuum curiosity

2017-12-17 Thread Rob Sargent
CAVEAT: I may have another version of this email bouncing around, sorry. Running PG10.0 on Centos 7.4 I thought the current database was quiescent so I’m curious about the line isolated below with “0 dead row" Does that suggest there is an open transaction? vacuum (analyse, verbose) sui.segment