Re: Heavy write activity on first vacuum of fresh TOASTa

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Heavy write activity on first vacuum of fresh TOASTa
Дата
Msg-id 8116.1197649369@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Heavy write activity on first vacuum of fresh TOASTa  (Matthew <matthew@flymine.org>)
Ответы Re: Heavy write activity on first vacuum of fresh TOASTa  (Matthew <matthew@flymine.org>)
Список pgsql-performance
Matthew <matthew@flymine.org> writes:
> Interesting thread. Now, I know absolutely nothing about how the data is
> stored, but it strikes me as being non-optimal that every single block on
> the disc needs to be written again just to update some hint bits. Could
> those bits be taken out into a separate bitmap stored somewhere else?

You are trying to optimize the wrong thing.  Making vacuum cheaper at
the cost of making every tuple lookup more expensive is not going to
be a win.

            regards, tom lane

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

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: viewing source code
Следующее
От: Matthew
Дата:
Сообщение: Re: Heavy write activity on first vacuum of fresh TOASTa