Stefano Nichele escribió: > Hi All, > I have a couple of questions about autovacuum/vacuum behavior. > > On my production system, I set autovacuum ON since it's pretty hard to > me find a good timeframe for vacuum (the system is pretty busy over the day) > Last week the system was really slow and running vacuum manually the > performance was really improved. > So now I would like to understand why autovacuum did not work as > expected (at least for me). Any ideas ? Maybe the autovacuum naptime was set too high. Or perhaps the threshold and scale settings were too high. Maybe the vacuum_cost_delay for autovacuum was too high. > Why autovacuum (that was OFF) started ? For preventing transaction ID > wraparound ? Is it right that in such case all the tables are > (auto)vacuumed ? Not necessarily all tables; only those that require a vacuum to prevent xid wraparound. (It was all tables in 8.1, but this changed in 8.2). -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
