Re: index files still growing - Mailing list pgsql-general

Doug McNaught <doug@wireboard.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