Request a Demo
Home   >   mailing lists

Re: visibility map and reltuples - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: visibility map and reltuples
Date
Msg-id [email protected]
Whole thread Raw
In response to Re: visibility map and reltuples  (Tom Lane <[email protected]>)
List pgsql-hackers
Tree view 
Tom Lane wrote:
> I think your previous sketch is right: suppress update of reltuples (and
> relpages) from a partial vacuum scan, and ensure that the analyze phase
> is allowed to do it instead if it happens during VACUUM ANALYZE.

We also mustn't reset n_live_tuples in pgstat in partial vacuum. 
Committed a patch to do that.

Thanks for the report!

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: ITAGAKI Takahiro
Date:
Subject: Re: parallel restore vs. windows
Next
From: Tatsuo Ishii
Date:
Subject: Re: WAL documentation changes