Index cleanup

Hi,

recently I went through some dev dbs just to clean up some unused
tables. What I found out afterwards is that even if you run a vacuum
full analyze it doesn't removed the index data.

So I was left with table size of a view bytes and gigabyte large indexes.

Of course a re-index cleaned that up.

My question now is, is this intended? Should vacuum full not clean out
the indexes if the table for this index is emptied or a lot of data is
removed.

Should that happen after some time? I doubt, because on one of my life
servers a test db had a size of 33MB overall, but an index size of 1.5GB ...

Whats the best way to handles this on a production system. I doubt its
wise to recreate indexes every month or so ...

--
[ Clemens Schwaighofer -----=====:::::~ ]
[ IT Engineer/Manager ]
[ E-Graphics Communications, TEQUILA\ Japan IT Group ]
[ 6-17-2 Ginza Chuo-ku, Tokyo 104-8167, JAPAN ]
[ Tel: +81-(0)3-3545-7706 Fax: +81-(0)3-3545-7343 ]
[ http://www.tequila.jp ]