Re: Problem with corrupt index

Diogo Biazus <diogo@ikono.com.br> writes:

> Hi everybody,
> I have a table that requires periodical updates (every 5 seconds) in
> more than one register.
> The table is very small (about 7 registers) and it wont grow.
> Sometimes the access to that table becomes very slow, and VACUUM dont
> fix it, I have to REINDEX the table.
> Anyone can tell me what should be the cause of this problem?

Indexes (currently) aren't affected by VACUUM.  You have to REINDEX
periodically, depending on table activity.

-Doug