Re: Information about Pages, row versions of tables, indices

Hello

look on contrib module pg_stat_tuple
http://www.postgresql.org/docs/8.3/interactive/pgstattuple.html

regards
Pavel Stehule

2008/12/25 Gerhard Wiesinger <lists@wiesinger.com>:
> Hello!
>
> Is there some information in meta tables available about the number of pages
> currently unused, row versions of tables and indices which are unused?
>
> I'm asking because I want to measure how efficient HOT is working and
> whether vacuum should be run or not saving diskspace (I know this is done
> automatically).
>
> Thanx.
>
> Ciao,
> Gerhard
>
> --
> http://www.wiesinger.com/
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>