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 1kc8VV-0001rx-QF for pgsql-hackers@arkaria.postgresql.org; Mon, 09 Nov 2020 14:50:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kc8VU-0001zP-MX for pgsql-hackers@arkaria.postgresql.org; Mon, 09 Nov 2020 14:50:56 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kc8VT-0001zI-HK for pgsql-hackers@lists.postgresql.org; Mon, 09 Nov 2020 14:50:55 +0000 Received: from mail1.dalibo.net ([212.83.143.11] helo=mail.dalibo.com) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kc8VQ-0005Te-SI for pgsql-hackers@postgresql.org; Mon, 09 Nov 2020 14:50:54 +0000 Received: from firost (larco.ioguix.net [82.66.0.6]) by mail.dalibo.com (Postfix) with ESMTPSA id 9D0EE2060A; Mon, 9 Nov 2020 15:50:49 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=dalibo.com; s=a; t=1604933449; bh=9/aPGiswRxHE4HeAyVhVh1mEzQvNBTcVLHj71+ge9pc=; h=Date:From:To:Cc:Subject:In-Reply-To:References:From; b=XtI+TKSX4em8UxVs6gEl8J6JJqzbKMwGUkkXb4sC3LWSzo0dUNB6IUzSGLg5+9Ov7 txIvgJfECUu+V3NjKf/B4uI0DZ0CACccjCktxCLblK29GhlUmcuJjYjYbRpLjVN+UY SvPgSz76lwNGJskcDdLRv1A6rIVdaTHAtOhglwVs= Date: Mon, 9 Nov 2020 15:50:49 +0100 From: Jehan-Guillaume de Rorthais To: Peter Geoghegan Cc: PostgreSQL-development Subject: Re: vacuum -vs reltuples on insert only index Message-ID: <20201109155049.46310a16@firost> In-Reply-To: References: <20201023174451.69e358f1@firost> Organization: Dalibo MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Wed, 4 Nov 2020 18:44:03 -0800 Peter Geoghegan wrote: > On Mon, Nov 2, 2020 at 10:03 AM Peter Geoghegan wrote: > > Actually, it seems better to always count num_index_tuples the old way > > during cleanup-only index VACUUMs, despite the inaccuracy that that > > creates with posting list tuples. > > Pushed a fix for this just now. > > Thanks for the report! Sorry I couldn't give some more feedback on your thoughts on time... Thank you for your investigation and fix! Regards,