pgsql: Avoid holding AutovacuumScheduleLock while rechecking table stat

2018-03-13 Thread Tom Lane
Avoid holding AutovacuumScheduleLock while rechecking table statistics. In databases with many tables, re-fetching the statistics takes some time, so that this behavior seriously decreases the available concurrency for multiple autovac workers. There's discussion afoot about more complete fixes,

pgsql: Avoid holding AutovacuumScheduleLock while rechecking table stat

2018-03-13 Thread Tom Lane
Avoid holding AutovacuumScheduleLock while rechecking table statistics. In databases with many tables, re-fetching the statistics takes some time, so that this behavior seriously decreases the available concurrency for multiple autovac workers. There's discussion afoot about more complete fixes,

pgsql: Avoid holding AutovacuumScheduleLock while rechecking table stat

2018-03-13 Thread Tom Lane
Avoid holding AutovacuumScheduleLock while rechecking table statistics. In databases with many tables, re-fetching the statistics takes some time, so that this behavior seriously decreases the available concurrency for multiple autovac workers. There's discussion afoot about more complete fixes,

pgsql: Avoid holding AutovacuumScheduleLock while rechecking table stat

2018-03-13 Thread Tom Lane
Avoid holding AutovacuumScheduleLock while rechecking table statistics. In databases with many tables, re-fetching the statistics takes some time, so that this behavior seriously decreases the available concurrency for multiple autovac workers. There's discussion afoot about more complete fixes,

pgsql: Avoid holding AutovacuumScheduleLock while rechecking table stat

2018-03-13 Thread Tom Lane
Avoid holding AutovacuumScheduleLock while rechecking table statistics. In databases with many tables, re-fetching the statistics takes some time, so that this behavior seriously decreases the available concurrency for multiple autovac workers. There's discussion afoot about more complete fixes,

pgsql: Avoid holding AutovacuumScheduleLock while rechecking table stat

2018-03-13 Thread Tom Lane
Avoid holding AutovacuumScheduleLock while rechecking table statistics. In databases with many tables, re-fetching the statistics takes some time, so that this behavior seriously decreases the available concurrency for multiple autovac workers. There's discussion afoot about more complete fixes,