Jason Slagle wrote:
> And how long is normal for Vacuum analyze to take on bout 350 megs of
> DATA?
>
> Jason
>
My database is 1.4 Gig. It takes about 2-3 minutes for a vacuum analyze verbose.
I have had problems in the past with a corrupted main index (the table of
tables). In such a case, the vacuum never stops even after > 48 hours. Try
vacuuming your tables one-by-one if you have really long vaccums (> 1 hour). If
the tables vacuum one-by-one alright, then you have a corrupted main index.
-Tony
