Re: Information about Pages, row versions of tables, indices - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Information about Pages, row versions of tables, indices
Date
Msg-id 162867790812250250x3fa50d27n3b366da8f9f95a6e@mail.gmail.com
Whole thread Raw
In response to Information about Pages, row versions of tables, indices  (Gerhard Wiesinger <lists@wiesinger.com>)
Responses Re: Information about Pages, row versions of tables, indices
List pgsql-general
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
>

pgsql-general by date:

Previous
From: Gerhard Wiesinger
Date:
Subject: Information about Pages, row versions of tables, indices
Next
From: Gerhard Wiesinger
Date:
Subject: Conditional commit inside functions