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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
