Gourish Singbal <gourish@gmail.com> writes:
> I need some help to decide when i should reindex the indexes in the table.
> ...
> When should i ideally reindex this table ?.
> (once in a month, weekly....etc)
It seems to need reindexing now, but that tells us nothing about how
often you might need to do it.
My advice is that you probably need to vacuum more often, rather than
deciding you need periodic reindexes.
regards, tom lane