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 11:05:10 -0600
|
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 |
- Follow-Ups:
- Re: Count not updated with VACUUM ANALYZE
- From: Guillaume Lelarge
- Re: Count not updated with VACUUM ANALYZE
- Prev by Date: Count not updated with VACUUM ANALYZE
- Next by Date: Trabajo sobre Postgresql
- Previous by thread: Count not updated with VACUUM ANALYZE
- Next by thread: Re: Count not updated with VACUUM ANALYZE
- Indexes: