Re: Count not updated with VACUUM ANALYZE

["Stephen Denne" <Stephen(dot)Denne(at)datamail(dot)co(dot)nz>]

> 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).

I think Guillaume meant "estimated" rather than "exact" here.

> 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.

There is an option under the Query tab named
"Count rows if estimated less than" 
which you could change to a larger number.

I have mine set to 0 as I don't like the delay, and the estimates fill my needs.

Regards,
Stephen Denne.

Disclaimer:
At the Datamail Group we value team commitment, respect, achievement, customer focus, and courage. This email with any attachments is confidential and may be subject to legal privilege.  If it is not intended for you please advise by reply immediately, destroy it and do not copy, disclose or use it in any way.
__________________________________________________________________
  This email has been scanned by the DMZGlobal Business Quality
              Electronic Messaging Suite.
Please see http://www.dmzglobal.com/dmzmessaging.htm for details.
__________________________________________________________________