BUG #17724: All autovacuum workers operate on 1 db at a time
| От | PG Bug reporting form |
|---|---|
| Тема | BUG #17724: All autovacuum workers operate on 1 db at a time |
| Дата | |
| Msg-id | 17724-37442ada79498fbb@postgresql.org обсуждение исходный текст |
| Ответы |
Re: BUG #17724: All autovacuum workers operate on 1 db at a time
|
| Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 17724 Logged by: Peter Plachta Email address: pplachta@gmail.com PostgreSQL version: Unsupported/Unknown Operating system: Windows (Azure) Description: Hi all I have observed this on PG 9.6 and 10 and could not find a bug indicating it was fixed. Issue is that autovacuum workers appear bound to a certain DB, even if there is more urgent (wraparound) work to do elsewhere. In our case specifically we have multiple DBs, one has a large table that for various reasons takes a long time (many hours) to vacuum. During this time other autovacuum workers are idle while our other DBs which do frequent insert/delete accumulate significant bloat which ends up affecting query time. Ideally the idle autovacuum workers would just proceed to the next DB.
В списке pgsql-bugs по дате отправления: