Re: Way to determine index bloat stats? - Mailing list pgsql-general

From Tom Lane
Subject Re: Way to determine index bloat stats?
Date
Msg-id 19801.1183659625@sss.pgh.pa.us
Whole thread Raw
In response to Way to determine index bloat stats?  (Jeff Amiel <jamiel@istreamimaging.com>)
List pgsql-general
Jeff Amiel <jamiel@istreamimaging.com> writes:
> Is there some magic way of determining the number of bytes in an index
> 'row' and then comparing the size on disk of the index file?

In recent releases contrib/pgstattuple/ has a function for obtaining
stats about an index.

            regards, tom lane

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: [pgsql-general] In memory tables/databases
Next
From: Ranieri Mazili
Date:
Subject: Working with dates