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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html