Re: a verbose option for autovacuum

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: a verbose option for autovacuum
Дата
Msg-id YFlvIwnocGyZjkcW@paquier.xyz
обсуждение исходный текст
Ответ на Re: a verbose option for autovacuum  (Masahiko Sawada <sawada.mshk@gmail.com>)
Ответы Re: a verbose option for autovacuum  (Masahiko Sawada <sawada.mshk@gmail.com>)
Список pgsql-hackers
On Mon, Mar 22, 2021 at 12:17:37PM +0900, Masahiko Sawada wrote:
> I've updated the patch. I saved the index names at the beginning of
> heap_vacuum_rel() for autovacuum logging, and add indstats and
> nindexes to LVRelStats. Some functions still have nindexes as a
> function argument but it seems to make sense since it corresponds the
> list of index relations (*Irel). Please review the patch.

Going back to that, the structure of the static APIs in this file make
the whole logic a bit hard to follow, but the whole set of changes you
have done here makes sense.  It took me a moment to recall and
understand why it is safe to free *stats at the end of
vacuum_one_index() and if the index stats array actually pointed to
the DSM segment correctly within the shared stats.

I think that there is more consolidation possible within LVRelStats,
but let's leave that for another day, if there is any need for such a
move.

To keep it short.  Sold.
--
Michael

Вложения

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: proposal - psql - use pager for \watch command
Следующее
От: Amul Sul
Дата:
Сообщение: Re: [CLOBBER_CACHE]Server crashed with segfault 11 while executing clusterdb