Re: [GENERAL] contrib/dbsize

[Joseph Shraibman]

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 [EMAIL PROTECTED]