Ron St-Pierre wrote: > Gregory Stark wrote: >>> We were running autovacuum but it interfered with the updates to we >>> shut it off. >> >> Was it just the I/O bandwidth? I'm surprised as your >> vacuum_cost_delay is quite high. Manual vacuum doesn't do anything >> differently from autovacuum, neither should interfere directly with >> updates except by taking away I/O bandwidth. >> > I don't know what the problem was. I tried to exclude certain tables > from autovacuuming, but it autovacuumed anyway. Probably because of Xid wraparound issues. Now that you're vacuuming weekly it shouldn't be a problem. (It's also much less of a problem in 8.2). -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
