> The Vacuum's don't take too long, 10 minutes at most.  I can tell from ps
> -ef | grep and top that its the selects/inserts/updates from the postgres
> related to our app that take all that time up.  If we rerun initdb and
> reload the data, it works great for about two days, then goes bad again.
> We are in the process of trying out 7.4.2 right now, just waiting on the
> reload of pg_dump.

Well, test running VACUUM ANALYZE as the "postgres" superuser and see if that 
fixes the issue.

-Josh Berkus
 Aglio Database Solutions
 San Francisco

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?


Reply via email to