| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Melvin Davidson <mdavidson(at)trenstar(dot)com> |
| Cc: | "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Re: Count not updated with VACUUM ANALYZE |
| Date: | 2008-03-27 00:03:54 |
| Message-ID: | 47EAE46A.10908@lelarge.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
Melvin Davidson a écrit :
> *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?
>
Nope. ANALYZE collects some statistics (for example an estimated number
of rows on each table... this number is available in pgAdmin under the
exact number of rows).
The Count item of the contextual menu does a count(*) on the table. So,
it gives you the exact number of rows.
> Also, is there an documented (or undocumented) function I can run to
> manually update the counts.
>
No. You really need to select the menu item "Count" to have the exact
number of rows.
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Denne | 2008-03-27 00:16:03 | Re: Count not updated with VACUUM ANALYZE |
| Previous Message | Jesus Borjas Paco | 2008-03-26 17:29:48 | Trabajo sobre Postgresql |