Anj Adu escribió: > We have a few 8.1 installations where the vacuumdb -a command takes > 2-3 days to run ..(with a vacuum delay of 10ms)...autovac does not > work for us as we have tables that get constantly dropped due to > partitioning.(autovac would never finish given the size of our > database
I think you should set pg_autovacuum.enabled=false for those tables to avoid having autovac work uselessly on them. > and the fact that we have some "idle transactions" caused by > our application server coneection pools.) If this is really a problem, it's not going to be limited to autovacuum; regular vacuum is going to be affected too. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
