public inbox for [email protected]  

help / color / mirror / Atom feed

From: Bruce Momjian <[email protected]>
To: David G. Johnston <[email protected]>
Cc: Peter Geoghegan <[email protected]>
Cc: Jonathan S. Katz <[email protected]>
Cc: Pg Docs <[email protected]>
Subject: Re: documentation on HOT
Date: Fri, 12 Aug 2022 15:07:22 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <YtoFKu1D/[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<CAH2-WznrTwM7iZ2_sHotqunBfLdCUD6y=uHJOzmVJ+NT46S0rg@mail.gmail.com>
	<[email protected]>
	<CAH2-Wz=s-ThOH=p7YfWwcUhXsi4xeb_nJ+-MhSaJOaEgBkL+kw@mail.gmail.com>
	<CAKFQuwamSjsy-DV9eTnLr=b8QfzRgc6SZ=bREYqQC=8PnLaYvQ@mail.gmail.com>
	<[email protected]>

On Tue, Jul 26, 2022 at 07:29:10PM -0400, Bruce Momjian wrote:
> > Summary paragraph:
> > "can only happen if" => "can only be created if"
> 
> Yes, good point.
> 
> Updated patch attached.

I applied this patch back to PG 11.  (PG 10 had too many conflicts.)  I
also added a mention about how indexes can prevent HOT to the index
introduction section;  applied patch of that addition attached.

-- 
  Bruce Momjian  <[email protected]>        https://momjian.us
  EDB                                      https://enterprisedb.com

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



Attachments:

  [text/x-diff] hot.diff (649B, 2-hot.diff)
  download | inline diff:
diff --git a/doc/src/sgml/indices.sgml b/doc/src/sgml/indices.sgml
index 023157d888..2a70e02f7c 100644
--- a/doc/src/sgml/indices.sgml
+++ b/doc/src/sgml/indices.sgml
@@ -103,7 +103,9 @@ CREATE INDEX test1_id_index ON test1 (id);
 
   <para>
    After an index is created, the system has to keep it synchronized with the
-   table.  This adds overhead to data manipulation operations.
+   table.  This adds overhead to data manipulation operations.  Indexes can
+   also prevent the creation of <link linkend="storage-hot">heap-only
+   tuples</link>.
    Therefore indexes that are seldom or never used in queries
    should be removed.
   </para>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: documentation on HOT
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox