> Whatever the case, the database still slows down to a halt after a month or
> so, and I have to go in and shut everything down and do a VACUUM FULL by
> hand.  One index (of many many) takes 2000 seconds to vacuum.  The whole
> process takes a few hours.

Do a REINDEX on that table instead, and regular vacuum more frequently.

> $ pg_config --version
>     PostgreSQL 7.3.2

7.4.x deals with index growth a little better 7.3 and older did.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to