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?
>
