Postgres Pro
Downloads
Home   >   mailing lists

Any way to 'analyze' indexes to get updated sizes? - Mailing list pgsql-performance

From Jeremy M. Guthrie
Subject Any way to 'analyze' indexes to get updated sizes?
Date
Msg-id 200404151248.16067.jeremy.guthrie@berbee.com
Whole thread Raw
Responses Use of subquery causes seq scan???
List pgsql-performance
Tree view 
-----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.guthrie@berbee.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-----

pgsql-performance by date:

Previous
From: "Matt Clark"
Date:
Subject: Re: Wierd context-switching issue on Xeon
Next
From: Dirk.Lutzebaeck@t-online.de (Dirk Lutzebaeck)
Date:
Subject: Re: Toooo many context switches (maybe SLES8?)