Count not updated with VACUUM ANALYZE - Mailing list pgadmin-support

From Melvin Davidson
Subject Count not updated with VACUUM ANALYZE
Date
Msg-id 5CA4D07E8D52ED4AB5499CA4E089858110A0A0EC9D@star2.corp.trenstar.net
Whole thread Raw
Responses Re: Count not updated with VACUUM ANALYZE  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgadmin-support
<div class="Section1"><p class="MsoNormal"><b><span style="font-family:"Arial","sans-serif";color:#1F497D">PgAdmin III
1.8.2</span></b><b><spanstyle="font-family:"Arial","sans-serif""></span></b><p class="MsoNormal"><span
style="color:#1F497D"> </span><pclass="MsoNormal"><span style="font-family:"Arial","sans-serif"">I have statistics
enabledon my server. However, when I do a VACUUM ANALYZE on my database, the count [ Rows (counted) ] is set to “not
counted”.</span><pclass="MsoNormal"><span style="font-family:"Arial","sans-serif""> </span><p class="MsoNormal"><span
style="font-family:"Arial","sans-serif"">NowI can right click on the individual tables and select “Count” to manually
updateit, but shouldn’t the VACUUM have done that?</span><p class="MsoNormal"><span
style="font-family:"Arial","sans-serif""> </span><pclass="MsoNormal"><span
style="font-family:"Arial","sans-serif"">Also,is there an documented (or undocumented) function I can run to manually
updatethe counts.</span><p class="MsoNormal"><span style="font-family:"Arial","sans-serif""> </span><p
class="MsoNormal"><spanstyle="font-family:"Arial","sans-serif"">Thanks in advance,</span><p class="MsoNormal"><span
style="font-family:"Arial","sans-serif"">MelvinDavidson</span></div> 

pgadmin-support by date:

Previous
From: "Eric P. Melbardis"
Date:
Subject: bug when creating/dropping function with a user defiend domain (adds size)
Next
From: Melvin Davidson
Date:
Subject: Count not updated with VACUUM ANALYZE