Re: error_severity of brin work item

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: error_severity of brin work item
Дата
Msg-id 20201130234732.GA12534@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: error_severity of brin work item  (Justin Pryzby <pryzby@telsasoft.com>)
Ответы Re: error_severity of brin work item  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-hackers
The more I look at this, the less I like it.  This would set a precedent
that any action that can be initiated from an autovac work-item has a
requirement of silently being discarded when it referenced a
non-existant relation.

I'd rather have the code that drops the index go through the list of
work-items and delete those that reference that relation.

I'm not sure if this is something that ought to be done in index_drop();
One objection might be that if the drop is rolled back, the work-items
are lost.  It's the easiest, though; and work-items are supposed to be
lossy anyway, and vacuum would fix the lack of summarization eventually.
So, not pretty, but not all that bad.  (Hopefully rolled-back drops are
not all that common.)



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

Предыдущее
От: David Steele
Дата:
Сообщение: Re: Online verification of checksums
Следующее
От: James Coleman
Дата:
Сообщение: Consider parallel for lateral subqueries with limit