Postgres Pro
Downloads
Home   >   mailing lists

Re: Vacuum takes a really long time, vacuum full required - Mailing list pgsql-performance

From Rod Taylor
Subject Re: Vacuum takes a really long time, vacuum full required
Date
Msg-id 1098200416.750.238.camel@home
Whole thread Raw
In response to Vacuum takes a really long time, vacuum full required  (Max Baker <max@warped.org>)
Responses Re: Vacuum takes a really long time, vacuum full required  (Max Baker <max@warped.org>)
Re: Vacuum takes a really long time, vacuum full required  (Max Baker <max@warped.org>)
List pgsql-performance
Tree view 
> 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.

pgsql-performance by date:

Previous
From: Max Baker
Date:
Subject: Vacuum takes a really long time, vacuum full required
Next
From: Andrew Sullivan
Date:
Subject: Re: Why isn't this index being used?