-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Is there a way to analyze indexes to provide updated sizes?  Is a vacuum the 
only way to determine the size of an index?  Analyze updates the stats so I 
can see table space sizes but I cannot find an alternative to vacuum for 
indexes.

- -- 

- --------------------------------------------------
Jeremy M. Guthrie        [EMAIL PROTECTED]
Network Engineer               Phone: 608-298-1061
Berbee                           Fax: 608-288-3007
5520 Research Park Drive         NOC: 608-298-1102
Madison, WI 53711
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQFAfsreqtjaBHGZBeURAm3+AJ9F34SESTf8i/oEuKvKfXoh+NcOxwCcDcM9
HP5LHM3Qidb4wa2/rW5H0cI=
=mJCz
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to