Horton

Re: Teaching users how they can get the most out of HOT in Postgres 14

Justin Pryzby <pryzby@telsasoft.com>

View thread View on postgr.es
From: Justin Pryzby <pryzby@telsasoft.com>
To: Peter Geoghegan <pg@bowt.ie>
Cc: Masahiko Sawada <sawada.mshk@gmail.com>, Michael Paquier <michael@paquier.xyz>, Andres Freund <andres@anarazel.de>, pgsql-hackers@lists.postgresql.org
Date: 2021-06-17T12:55:32Z
Lists: pgsql-hackers 
+      <literal>AUTO</literal>.  With <literal>OFF</literal> index
+      cleanup is disabled, with <literal>ON</literal> it is enabled,

OFF comma

+      bypassing index cleanup in cases where there is more than zero
+      dead tuples.

*are* more than zero
Or (preferably): "cases when there are no dead tuples at all"

+      If <literal>INDEX_CLEANUP</literal> is set to
+      <literal>OFF</literal> performance may suffer, because as the

OFF comma

+      removed until index cleanup is completed.  This option has no
+      effect for tables that do not have an index and is ignored if
+      the <literal>FULL</literal> option is used.

I'd say "tables that have no indexes,"

-- 
Justin

Commits

  1. Support disabling index bypassing by VACUUM.

  2. Teach VACUUM to bypass unnecessary index vacuuming.