Re: contrib/dbsize

[Joseph Shraibman <jks@xxxxxxxxxxxxxxx>]

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


Michael Fuhr wrote:
> On Tue, Apr 05, 2005 at 12:24:02PM -0400, Joseph Shraibman wrote:
>
> > How come relation_size() doesn't work on an index?
>
>
> Could you define "doesn't work"?  An example with the expected and
> actual output might show what's happening.
>
> I just ran some simple tests and relation_size() correctly showed
> the on-disk size of the file that stores the index.  Are you expecting
> something different?  Or have you found a case where relation_size()
> returns the wrong value?

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx