Re: visibility map and reltuples

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: "Ned T(dot) Crigler" <crigler(at)users(dot)sourceforge(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Greg Stark <greg(dot)stark(at)enterprisedb(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: visibility map and reltuples
Date: 2008-12-17 09:15:56
Message-ID: 4948C34C.1000209@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2008-12-17 09:22:01 Re: WAL documentation changes
Previous Message ITAGAKI Takahiro 2008-12-17 08:57:59 Re: parallel restore vs. windows