Re: Corrupt index stopping autovacuum system wide

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Corrupt index stopping autovacuum system wide
Дата
Msg-id 24777.1563382630@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Corrupt index stopping autovacuum system wide  (Peter Geoghegan <pg@bowt.ie>)
Ответы Re: Corrupt index stopping autovacuum system wide  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-general
Peter Geoghegan <pg@bowt.ie> writes:
> On Wed, Jul 17, 2019 at 8:54 AM Aaron Pelz <aaronepelz@gmail.com> wrote:
>> To me it looks like a *single* corrupt index held up autovacuums across our entire server, even other in other
databaseson the same server. Am I interpreting this correctly? 

> Yes -- that is correct.

It looks that way, but how would a broken non-shared index have held up
autovacuuming in other databases?  Maybe, as this one's xmin horizon
got further and further behind, the launcher eventually stopped
considering launching workers into any other databases?  That seems
like a bad thing; it's postponing work that will need to be done
eventually.

            regards, tom lane



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

Предыдущее
От: Aaron Pelz
Дата:
Сообщение: Re: Corrupt index stopping autovacuum system wide
Следующее
От: Sonam Sharma
Дата:
Сообщение: Change in db size