=20
> Melvin Davidson a =E9crit :
> > *PgAdmin III 1.8.2***
> >=20
> >=20=20
> >=20
> > I have statistics enabled on my server. However, when I do a VACUUM=20
> > ANALYZE on my database, the count [ Rows (counted) ] is set to =93not=
=20
> > counted=94.
> >=20
> >=20=20
> >=20
> > Now I can right click on the individual tables and select=20
> =93Count=94 to=20
> > manually update it, but shouldn=92t the VACUUM have done that?
> >=20
>=20
> Nope. ANALYZE collects some statistics (for example an=20
> estimated number=20
> of rows on each table... this number is available in pgAdmin=20
> under the=20
> 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=20
> table. So,=20
> it gives you the exact number of rows.
>=20
> > Also, is there an do***ented (or undo***ented) function I=20
> can run to=20
> > manually update the counts.
> >=20
>=20
> No. You really need to select the menu item "Count" to have the exact=20
> number of rows.
There is an option under the Query tab named
"Count rows if estimated less than"=20
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
n=
eeds.
Regards,
Stephen Denne.
Disclaimer:
At the Datamail Group we value team commitment, respect, achievement,
custo=
mer 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
a=
dvise 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.
__________________________________________________________________
--=20
Sent via pgadmin-sup****t mailing list (pgadmin-sup****t@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-sup****t
|
