[DOC] Document auto vacuum interruption

Поиск
Список
Период
Сортировка
От James Coleman
Тема [DOC] Document auto vacuum interruption
Дата
Msg-id CAAaqYe-XYyNwML1=f=gnd0qWg46PnvD=BDrCZ5-L94B887XVxQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: [DOC] Document auto vacuum interruption  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
We've discussed this internally many times, but today finally decided
to write up a doc patch.

Autovacuum holds a SHARE UPDATE EXCLUSIVE lock, but other processes
can cancel autovacuum if blocked by that lock unless the autovacuum is
to prevent wraparound.This can result in very surprising behavior:
imagine a system that needs to run ANALYZE manually before batch jobs
to ensure reasonable query plans. That ANALYZE will interrupt attempts
to run autovacuum, and pretty soon the table is far more bloated than
expected, and query plans (ironically) degrade further.

Attached is a patch to document that behavior (as opposed to just in
the code at src/backend/storage/lmgr/proc.c:1320-1321).

James Coleman

Вложения

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [Proposal] Table-level Transparent Data Encryption (TDE) and KeyManagement Service (KMS)
Следующее
От: Daniel Migowski
Дата:
Сообщение: Question about MemoryContexts / possible memory leak inCachedPlanSource usage