Anjan,
> This is what I used to find the table size, which probably doesn't
> include the index size. Is there a way to find out size of indexes?
>
> select relpages * 8192 as size_in_bytes from pg_class where relnamespace
> = (select oid from pg_namespace where nspname = 'public') and relname =
> 'r_itemcategory';
See the code in CVS in the "newsysviews" project in pgFoundry. Andrew coded
up a nice pg_user_table_storage view which gives table, index and TOAST size.
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco