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 1jYIhA-0002bQ-V1 for pgsql-hackers@arkaria.postgresql.org; Tue, 12 May 2020 00:22:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jYIh9-0005Xc-IB for pgsql-hackers@arkaria.postgresql.org; Tue, 12 May 2020 00:22:51 +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 1jYIh9-0005XV-Bj for pgsql-hackers@lists.postgresql.org; Tue, 12 May 2020 00:22:51 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jYIh6-0005Wn-MT for pgsql-hackers@postgresql.org; Tue, 12 May 2020 00:22:50 +0000 Received: from bruce by momjian.us with local (Exim 4.92) (envelope-from ) id 1jYIh4-0005IA-MO; Mon, 11 May 2020 20:22:46 -0400 Date: Mon, 11 May 2020 20:22:46 -0400 From: Bruce Momjian To: Amit Kapila Cc: PostgreSQL-development Subject: Re: PG 13 release notes, first draft Message-ID: <20200512002246.GJ4666@momjian.us> References: <20200505031600.GB21752@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Mon, May 11, 2020 at 10:52:41AM +0530, Amit Kapila wrote: > One more observation: > > Allow inserts to trigger autovacuum activity (Laurenz Albe, Darafei > Praliaskouski) > This new behavior allows pages to be set as all-visible, which then > allows index-only scans, ... > > The above sentence sounds to mean that this feature allows index-only > scans in more number of cases after this feature. Is that what you > intend to say? If so, is that correct? Because I think this will Yes. > allow index-only scans to skip "Heap Fetches" in more cases. Uh, by definition an index-only scan only scans the index, not the heap, right? It is true there are fewer heap fetches, but fewer heap features I thought mean more index-only scans. -- Bruce Momjian https://momjian.us EnterpriseDB https://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +