Re: contrib/dbsize - Mailing list pgsql-general

From Michael Fuhr
Subject Re: contrib/dbsize
Date
Msg-id 20050405173615.GA26610@winnie.fuhr.org
Whole thread Raw
In response to Re: contrib/dbsize  (Joseph Shraibman <jks@selectacast.net>)
Responses Re: contrib/dbsize  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-general
On Tue, Apr 05, 2005 at 01:25:01PM -0400, Joseph Shraibman wrote:
> local]:o=>select version();
>                                                  version
> ---------------------------------------------------------------------------------------------------------
>  PostgreSQL 7.4.7 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2
> 20030222 (Red Hat Linux 3.2.2-5)
> (1 row)
>
> [local]:o=>select  relation_size('pg_am_oid_index');
> ERROR:  "pg_am_oid_index" is an index

Looks like this has been fixed in PostgreSQL 8.x.

http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dbsize/dbsize.c

test=> SELECT version();
                                    version
--------------------------------------------------------------------------------
 PostgreSQL 8.0.2beta1 on sparc-sun-solaris2.9, compiled by GCC gcc (GCC) 3.4.2
(1 row)

test=> SELECT relation_size('pg_am_oid_index');
 relation_size
---------------
         16384
(1 row)

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: Joseph Shraibman
Date:
Subject: Re: contrib/dbsize
Next
From: Joseph Shraibman
Date:
Subject: Re: contrib/dbsize