Postgres Pro
Downloads
Home   >   mailing lists

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

From Gerhard Wiesinger
Subject Information about Pages, row versions of tables, indices
Date
Msg-id alpine.LFD.1.10.0812251055460.24901@bbs.intern
Whole thread Raw
Responses Re: Information about Pages, row versions of tables, indices  ("Pavel Stehule" <pavel.stehule@gmail.com>)
List pgsql-general
Tree view 
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/

pgsql-general by date:

Previous
From: "Charles.Hou"
Date:
Subject: get the array value?
Next
From: "Pavel Stehule"
Date:
Subject: Re: Information about Pages, row versions of tables, indices