Doug McNaught <doug(at)wireboard(dot)com> writes:
>> My solution is to DROP & CREATE my indexes files once
>> a week.
> Your solution is currently the only one available. Not pretty, but it
> works.
REINDEX is a marginally prettier answer; at least you don't have to
remember the index parameters. Shrinking indexes on-the-fly is still
on the TODO list.
regards, tom lane