Re: Dead Space Map version 3 (simplified) - Mailing list pgsql-patches

From Hiroki Kataoka
Subject Re: Dead Space Map version 3 (simplified)
Date
Msg-id 462C38F1.6040300@interwiz.jp
Whole thread Raw
In response to Re: Dead Space Map version 3 (simplified)  (Heikki Linnakangas <heikki@enterprisedb.com>)
Responses Re: Dead Space Map version 3 (simplified)
List 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 by date:

Previous
From: Koichi Suzuki
Date:
Subject: Re: [HACKERS] Full page writes improvement, code update
Next
From: Gregory Stark
Date:
Subject: Re: Dead Space Map version 3 (simplified)