Fabio,
> 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