Re: vacuum full

On Thu, 21 Nov 2002, Henrik Steffen wrote:

> sorry, didn't notice your message posted to pgsql-general...
>
> but is there any method to see the size in bytes a particular index
> for a particular table takes?

There are some sql queries that can tell you the number of blocks used and
all, but I generally do it with oid2name (you can get it installed by
going into your source tree/contrib/oid2name and doing a make/make install
there.)

oid2name by itself will tell you the oids of your databases.  On my fairly
fresh system it looks like this:

All databases:
---------------------------------
16976  = postgres
1      = template1
16975  = template0

Then,

'oid2name -d postgres' outputs this:

16999  = g
17025  = g_name_dx
16977  = gaff
16988  = test
16986  = test_id_seq
17019  = tester

So, I can do this 'ls -l $PGDATA/base/16976/17025'

to see how big the index g_name_dx is.