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

From Melvin Davidson
Subject Count not updated with VACUUM ANALYZE
Date
Msg-id 5CA4D07E8D52ED4AB5499CA4E089858110A0A0EC9A@star2.corp.trenstar.net
Whole thread
List pgadmin-support

I have statistics enabled on my server. However, when I do a VACUUM ANALYZE on my database, the count [ Rows (counted) ] is set to “not counted”.

 

Now I can right click on the individual tables and select “Count” to manually update it, but shouldn’t the VACUUM have done that?

 

Also, is there an documented (or undocumented) function I can run to manually update the counts.

 

Thanks in advance,

Melvin Davidson

 

pgadmin-support by date:

Previous
From: Melvin Davidson
Date:
Subject: Count not updated with VACUUM ANALYZE
Next
From: "Jesus Borjas Paco"
Date:
Subject: Trabajo sobre Postgresql