John Scalia wrote: > autovacuum_vacuum_cost_limit is currently set at -1. Not really sure what > it should be, as I still need to look that up. Yes, I saw that from your snippet, but that value means to use the value from vacuum_cost_limit. If that one is set to a positive value, it may lead to sleeps during vacuum. Also, tables could have values set in pg_class.reloptions, leading to sleeps. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin