Re: documentation on HOT

On Fri, Jul 22, 2022 at 11:09:49AM -0400, Jonathan Katz wrote:
> On 7/22/22 8:51 AM, Bruce Momjian wrote:
> > URL contents updated too:
> >
> > https://momjian.us/tmp/pgsql/storage-hot.html
>
> Thanks! This is great. Probably the most concise and clear explanation I
> have seen for HOT, which is exactly what we need for the docs :)
>
> A few suggestions:
>
> s/Fortunately, there is/To help reduce overhead, PostgreSQL has/

So, I can't do that without making the later part of the sentence
redundant. I adjusted it in the attached patch.
>
> s/In summary, h/H/

Uh, I don't want to remove that since I am restating what I said above
--- do you have another approach?

> > You can increase the change of HOT updates by using non-default table
> fillfactor settings.
>
> I think we should expand on this and explain how adjusting "fillfactor" will
> affect this. I think that may change the final sentence too.

Okay, done in the attached patch.

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

Indecision is a decision. Inaction is an action. Mark Batterson