Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nGtGy-0006vL-JO for pgsql-docs@arkaria.postgresql.org; Mon, 07 Feb 2022 01:56:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nGtGx-0002Uj-4g for pgsql-docs@arkaria.postgresql.org; Mon, 07 Feb 2022 01:56:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nGtGw-0002Ua-Rd for pgsql-docs@lists.postgresql.org; Mon, 07 Feb 2022 01:56:54 +0000 Received: from mail-ua1-x931.google.com ([2607:f8b0:4864:20::931]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nGtGt-0000BZ-I1 for pgsql-docs@lists.postgresql.org; Mon, 07 Feb 2022 01:56:54 +0000 Received: by mail-ua1-x931.google.com with SMTP id w18so17125136uar.8 for ; Sun, 06 Feb 2022 17:56:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=X9Y8HaBZ54pEAKJVsRXGccI/XBWVlb8Zdt1/cxhL37c=; b=Hyi99iHiOfHJhxvRNX3h0qMJHB3M08DjKDiEWveMt7y6k+qP0kEdvm/Zs6cdoW9Ymh lSiah5fR4sfkBEY1IiPrRQwH9JdcQMVtojG9v/alkUAmfOariDkTXno0wnp3qv78BISN 3dyZt598iMvQSXe0xWrUtYzCUgk1MJZSVMTCupgRx58cp//HiFhrjkv09r2xjxMCMTtY 8onsHVFg0hIgH9n8TUjPCuafDWQkMhPJAXiVN+g+uYqNkpQOsuUlsY9iu/NwklPDkkFz j/vL263basmVEOpvZ0AX9fCz8AizUB63xmt0dXzVFv5veF3fiHUbL0D5aZCEziTzk9GL EZqA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=X9Y8HaBZ54pEAKJVsRXGccI/XBWVlb8Zdt1/cxhL37c=; b=wiWaLRU5Gz6gYgqhYHjlhVtxp7wzOXbMPX1pZqWyH5ZLyYh8Tnvyv/ePVb+nGRJnaE MsmRLMLonjiPGmoFBPOhNRwuByPbS/nlTR4ZbQKh5fwIuLvNqXcIhDvTvmox3tWAPpU4 SvqRZWWJxWJHo+6A9co8LKkiw0TF08ctBduOHFt6R3shGtiNBVrOaYJIGg6Kf3CKb+uk WkoBlBOvNQKSHtCzjQQVNCu4ycoS3ja+TwlmgVwQHrzNcwYbAKnuY5JpIrCdPFz5D9U3 7NZaFLYwMbmHG4kFW4eYgl+zUNJm2iJuEOT8/uhnwyoMqiuw5QdfWvnCoGkDzxNHiw/o lCyg== X-Gm-Message-State: AOAM531Zju2pOXpKF6pD99TVbI/Wr9uHT7PrY+UoKFVSZRzzNN2y2OCM +Q0Y/GCxFYwkkkgzIED2GA2Y0XxeoFLdS2pKy8BbHQGk/Mk= X-Google-Smtp-Source: ABdhPJzt+oF2GuimJ+NJurQLbBuv+aUUsG4ABQLwIJJ18OSxi5NGG8rh76nyebllT3kz7obX4snFrW+szNg5fk7L0yc= X-Received: by 2002:a67:b914:: with SMTP id q20mr4047774vsn.47.1644199008763; Sun, 06 Feb 2022 17:56:48 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: "David G. Johnston" Date: Sun, 6 Feb 2022 18:56:32 -0700 Message-ID: Subject: Re: documentation on HOT To: "Jonathan S. Katz" Cc: Pg Docs Content-Type: multipart/alternative; boundary="000000000000db895f05d763e95c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000db895f05d763e95c Content-Type: text/plain; charset="UTF-8" On Sun, Feb 6, 2022 at 6:08 PM Jonathan S. Katz wrote: > > Given the importance of HOT, it seems like this would be a good topic to > document. I would suggest something higher-level for general users in > the "Indexes"[4] section, and something lower-level in internals[5] > (which could perhaps be derived from [2]). > > Thoughts on this? > I'm doubting there is any disagreement that this is needed. Three of us said as much recently [1] while discussing a user question regarding our documentation for expression indexes. [1] https://www.postgresql.org/message-id/flat/CAKFQuwY2MAhXTpPNG9cBA135GAOPcZ0jK-QkqW8_VCGQDJXtjQ%40mail.gmail.com#1f060009bf7009b0d74cb9af042ccef7 I presently haven't felt moved to fill the need myself as so I was fine with at least providing a high-level summary in the glossary which we also the general user to understand the idea without having to dive into the README. The details for internals can continue to be handled there in the interest of at least getting something committed for the majority of users. David J. --000000000000db895f05d763e95c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Sun, Feb 6, 2022 at 6:08 PM Jonathan S. Katz <jkatz@postgresql.org> wrote:

Given the importance of HOT, it seems like this would be a good topic to document. I would suggest something higher-level for general users in
the "Indexes"[4] section, and something lower-level in internals[= 5]
(which could perhaps be derived from [2]).

Thoughts on this?

I'm doubting t= here is any disagreement that this is needed.=C2=A0 Three of us said as muc= h recently [1] while discussing a user question regarding our documentation= for expression indexes.


<= div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif= ">I presently haven't felt moved to fill=C2=A0the need myself as so I w= as fine with at least providing a high-level summary in the glossary which = we also the general user to understand the idea without having to dive into= the README.=C2=A0 The details for internals can continue to be handled the= re in the interest of at least getting something committed for the majority= of users.

David J.

--000000000000db895f05d763e95c--