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

From Heikki Linnakangas
Subject Re: visibility map and reltuples
Date
Msg-id 4948C34C.1000209@enterprisedb.com
Whole thread Raw
In response to Re: visibility map and reltuples  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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