Count not updated with VACUUM ANALYZE
От | Melvin Davidson |
---|---|
Тема | Count not updated with VACUUM ANALYZE |
Дата | |
Msg-id | 5CA4D07E8D52ED4AB5499CA4E089858110A0A0EC9A@star2.corp.trenstar.net обсуждение исходный текст |
Список | pgadmin-support |
<div class="Section1"><p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">I have statistics enabled on myserver. 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><p class="MsoNormal"><span style="font-family:"Arial","sans-serif""> </span></div>
В списке pgadmin-support по дате отправления: