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.