Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group