Re: Convenient dump of table and object size in PG 7.4

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)surnet(dot)cl>
Cc: Steve Lane <slane(at)soliantconsulting(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Convenient dump of table and object size in PG 7.4
Date: 2005-05-27 03:17:20
Message-ID: 10450.1117163840@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Alvaro Herrera <alvherre(at)surnet(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message =?iso-2022-jp?B?IpV4jlKLYJRWIiA8bWFyYXNvbkBvay5rej4N?= 2005-05-27 11:34:14 HH
Previous Message Alvaro Herrera 2005-05-27 02:48:12 Re: Convenient dump of table and object size in PG 7.4