| From: | "Jeremy M(dot) Guthrie" <jeremy(dot)guthrie(at)berbee(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Any way to 'analyze' indexes to get updated sizes? |
| Date: | 2004-04-15 17:48:14 |
| Message-ID: | 200404151248.16067.jeremy.guthrie@berbee.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
-----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 jeremy(dot)guthrie(at)berbee(dot)com
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-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | J. Andrew Rogers | 2004-04-15 18:28:26 | Re: linux distro for better pg performance |
| Previous Message | Richard Huxton | 2004-04-15 17:44:33 | Re: [ SOLVED ] select count(*) very slow on an already |