X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2EB0DD1D083 for ; Thu, 15 Apr 2004 14:48:14 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 37464-05 for ; Thu, 15 Apr 2004 14:48:17 -0300 (ADT) Received: from ctg-msnexc01.staff.berbee.com (msn-office1.binc.net [64.73.12.254]) by svr1.postgresql.org (Postfix) with ESMTP id D46C1D1D07E for ; Thu, 15 Apr 2004 14:48:11 -0300 (ADT) Received: from localhost ([172.30.254.220] RDNS failed) by ctg-msnexc01.staff.berbee.com with Microsoft SMTPSVC(6.0.3790.0); Thu, 15 Apr 2004 12:48:16 -0500 From: "Jeremy M. Guthrie" Reply-To: jeremy.guthrie@berbee.com Organization: Berbee Information Networks To: pgsql-performance@postgresql.org Subject: Any way to 'analyze' indexes to get updated sizes? Date: Thu, 15 Apr 2004 12:48:14 -0500 User-Agent: KMail/1.6.1 MIME-Version: 1.0 Content-Disposition: inline Content-Type: Text/Plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Message-Id: <200404151248.16067.jeremy.guthrie@berbee.com> X-OriginalArrivalTime: 15 Apr 2004 17:48:16.0425 (UTC) FILETIME=[D4C40990:01C42311] X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/297 X-Sequence-Number: 6597 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Is there a way to analyze indexes to provide updated sizes? Is a vacuum th= e=20 only way to determine the size of an index? Analyze updates the stats so I= =20 can see table space sizes but I cannot find an alternative to vacuum for=20 indexes. - --=20 - -------------------------------------------------- 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=3D =3DmJCz -----END PGP SIGNATURE-----