Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Count not updated with VACUUM ANALYZE
- From: Melvin Davidson <mdavidson(at)trenstar(dot)com>
- To: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
- Subject: Count not updated with VACUUM ANALYZE
- Date: Wed, 26 Mar 2008 10:58:04 -0600
- Message-id: <5CA4D07E8D52ED4AB5499CA4E089858110A0A0EC9A(at)star2(dot)corp(dot)trenstar(dot)net>
|
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 |
- Prev by Date: bug when creating/dropping function with a user defiend domain (adds size)
- Next by Date: Count not updated with VACUUM ANALYZE
- Previous by thread: bug when creating/dropping function with a user defiend domain (adds size)
- Next by thread: Count not updated with VACUUM ANALYZE
- Indexes: