Chips8
02-09-2010, 12:32 PM
Ever since I upgraded to 1.09 (I'm on 1.10.01 now), I can't use the the "Vacuum Analyze Database" automatic option from "Options" in HEM. It always gives me an error message. It used to take about 30 seconds doing that.
I now have to manually vacuum option in PGAdmin III and that takes about 60 minutes. When I do the "reindex" in PGAdmin III, it takes about 90 minutes.
Is there a script I can use so that "Reindex" will run right after "Vacuum?" I'd like to set them to run overnight. Or can you explain why the automatic vacuum doesn't work?
I now have to manually vacuum option in PGAdmin III and that takes about 60 minutes. When I do the "reindex" in PGAdmin III, it takes about 90 minutes.
Is there a script I can use so that "Reindex" will run right after "Vacuum?" I'd like to set them to run overnight. Or can you explain why the automatic vacuum doesn't work?