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@xxxxxxxxxxxxx>: > 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
