Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Thu, May 26, 2005 at 09:39:26PM -0500, Steve Lane wrote:
>> Object sizes are computed from pg_class.relpages with an assumed page size
>> of 8192.
> Additionally, "show block_size" will give you the block (page) size. I
> don't see how would you use
On Thu, May 26, 2005 at 09:39:26PM -0500, Steve Lane wrote:
> Attached is a view I wrote for postgres 7.4 that seems to provide pretty
> accurate reporting of table sizes. For each non-system table in a database
> it shows base table size, size of any related TOAST data, and aggregate size
> of in
Hello all:
Attached is a view I wrote for postgres 7.4 that seems to provide pretty
accurate reporting of table sizes. For each non-system table in a database
it shows base table size, size of any related TOAST data, and aggregate size
of indexes.
The code is somewhat ugly in that it contains a b
