Count not updated with VACUUM ANALYZE

Поиск
Список
Период
Сортировка
От Melvin Davidson
Тема Count not updated with VACUUM ANALYZE
Дата
Msg-id 5CA4D07E8D52ED4AB5499CA4E089858110A0A0EC9D@star2.corp.trenstar.net
обсуждение исходный текст
Ответы Re: Count not updated with VACUUM ANALYZE  (Guillaume Lelarge <guillaume@lelarge.info>)
Список 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 по дате отправления:

Предыдущее
От: "Eric P. Melbardis"
Дата:
Сообщение: bug when creating/dropping function with a user defiend domain (adds size)
Следующее
От: Melvin Davidson
Дата:
Сообщение: Count not updated with VACUUM ANALYZE