Re: Convenient dump of table and object size in PG 7.4 - Mailing list pgsql-admin

From Tom Lane
Subject Re: Convenient dump of table and object size in PG 7.4
Date
Msg-id 10450.1117163840@sss.pgh.pa.us
Whole thread Raw
In response to Re: Convenient dump of table and object size in PG 7.4  (Alvaro Herrera <alvherre@surnet.cl>)
List pgsql-admin
Alvaro Herrera <alvherre@surnet.cl> 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 that in a query though.

current_setting('block_size')

            regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend


pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Convenient dump of table and object size in PG 7.4
Next
From: Dani Oderbolz
Date:
Subject: UNICODE issues with postgres