Re: documentation on HOT - Mailing list pgsql-docs

From Bruce Momjian
Subject Re: documentation on HOT
Date
Msg-id YtrZXSXJwWEyjQ37@momjian.us
Whole thread Raw
In response to Re: documentation on HOT  ("Jonathan S. Katz" <jkatz@postgresql.org>)
Responses Re: documentation on HOT
List pgsql-docs
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@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

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


Attachment

pgsql-docs by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: documentation on HOT
Next
From: Bruce Momjian
Date:
Subject: Re: documentation on HOT