On Tue, Jan 6, 2009 at 3:01 PM, Alvaro Herrera
<alvherre@commandprompt.com> wrote:
> Dan Armbrust escribió:
>
>> What on earth could be going on between PostgreSQL 8.1 and Fedora 6
>> that is bloating and/or corrupting the indexes like this?
>
> Postgres 8.1 was slow to vacuum btree indexes. My guess is that your
> indexes are so bloated that it takes a lot of time to scan them.
>
> I think the solution here is to vacuum this table far more often.
>
> --
> Alvaro Herrera http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>
Actually, the customer reported problem is that when they enable
autovacuum, the performance basically tanks because vacuum runs so
slow they can't bear to have it run frequently.
Though, perhaps they had bloated indexes before they started
autovacuum, and it never fixed them. Perhaps it will behave properly
if we do a reindex, and then enable autovacuum.