Re: Dead Space Map version 3 (simplified)

Поиск
Список
Период
Сортировка
От Hiroki Kataoka
Тема Re: Dead Space Map version 3 (simplified)
Дата
Msg-id 462C38F1.6040300@interwiz.jp
обсуждение исходный текст
Ответ на Re: Dead Space Map version 3 (simplified)  (Heikki Linnakangas <heikki@enterprisedb.com>)
Ответы Re: Dead Space Map version 3 (simplified)
Список pgsql-patches
Heikki Linnakangas wrote:
> The way you update the DSM is quite interesting. When a page is dirtied,
> the BM_DSM_DIRTY flag is set in the buffer descriptor. The corresponding
> bit in the DSM is set lazily in FlushBuffer whenever BM_DSM_DIRTY is
> set. That's a clever way to avoid contention on updates. But does it
> work for tables that have a small hot part that's updated very
> frequently?

I think there is no problem.  Bloating will make pages including the
unnecessary area which will not be accessed.  Soon, those pages will be
registered into DSM.

Or, though it expands however, do you assume accessing all pages equally?

--
Hiroki Kataoka <kataoka@interwiz.jp>

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

Предыдущее
От: Koichi Suzuki
Дата:
Сообщение: Re: [HACKERS] Full page writes improvement, code update
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: Dead Space Map version 3 (simplified)