Does raising maintenance_work_mem get seen by an already running aucovac?

Поиск
Список
Период
Сортировка
От Jerry Sievers
Тема Does raising maintenance_work_mem get seen by an already running aucovac?
Дата
Msg-id m0y1pqcxl9.fsf@comcast.net
обсуждение исходный текст
Ответы Re: Does raising maintenance_work_mem get seen by an already running aucovac?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Groovy admins,

This is on Pg11 (shameful, I know !).

There's a long running anti-wrap autovac that we'd rather let finish but
on the server instance, I found maintenance_work_mem rather low and thus
raised it in postgresql.comf, reloaded and confirmed that my interactive
session saw the change.

Can a running autovac make use of this or should I either wait it out or
cancel and let it restart when ready?

The vacuum progress view shows that it's finished the heap and I guess
toast, but is now working through the indexes.

Thx



В списке pgsql-admin по дате отправления:

Предыдущее
От: Jille Timmermans
Дата:
Сообщение: pgperms: Declarative / config as code for PostgreSQL permissions
Следующее
От: Clive Swan
Дата:
Сообщение: Long running queries