Request a Demo
Home   >   mailing lists

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
Responses Re: Count not updated with VACUUM ANALYZE
List pgadmin-support
Tree view

PgAdmin III 1.8.2

 

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: "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