Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hiWWU-0002G7-6Q for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Jul 2019 04:05:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hiWWT-0003Jl-3l for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Jul 2019 04:05:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hiWWS-0003Je-RJ for pgsql-hackers@lists.postgresql.org; Wed, 03 Jul 2019 04:05:32 +0000 Received: from kaemail1.nttcom.co.jp ([132.222.121.19]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hiWWO-0000OQ-Ij for pgsql-hackers@lists.postgresql.org; Wed, 03 Jul 2019 04:05:31 +0000 Received: from atmf.nttcom.co.jp (unknown [10.133.230.134]) by kaemail1.nttcom.co.jp (Unknown) with ESMTP id D6C7CFF88C; Wed, 3 Jul 2019 13:05:24 +0900 (JST) Received: from 10.133.230.129 (10.133.230.129) by MAIL-FILTER-SERVER with ESMTP; Wed, 3 Jul 2019 13:07:19 +0900 Received: from kaimail1.nttcom.co.jp (kaimvc1 [10.144.3.19]) by kaimail1.nttcom.co.jp (Postfix) with ESMTP id 7E34F2057E; Wed, 3 Jul 2019 13:05:24 +0900 (JST) Received: from WMCAS6.soad.nttcom.co.jp (wmcas6.soad.nttcom.co.jp [10.144.1.141]) by kaimail1.nttcom.co.jp (Postfix) with ESMTP id 70A572052D; Wed, 3 Jul 2019 13:05:24 +0900 (JST) Received: from [10.132.13.136] (10.132.13.136) by WMCAS6.soad.nttcom.co.jp (10.144.1.141) with Microsoft SMTP Server id 14.3.146.0; Wed, 3 Jul 2019 13:05:24 +0900 Subject: Re: progress report for ANALYZE To: Alvaro Herrera , Pg Hackers References: <20190621185207.GA27929@alvherre.pgsql> From: Tatsuro Yamada Message-ID: <45c2a6c0-80a1-0c55-b7d8-4ee15fd17841@nttcom.co.jp> Date: Wed, 3 Jul 2019 13:05:24 +0900 User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: <20190621185207.GA27929@alvherre.pgsql> Content-Type: text/plain; charset="windows-1252"; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit X-Originating-IP: [10.132.13.136] X-TM-AS-MML: disable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi Alvaro! On 2019/06/22 3:52, Alvaro Herrera wrote: > Hello > > Here's a patch that implements progress reporting for ANALYZE. Sorry for the late reply. My email address was changed to tatsuro.yamada.tf@nttcom.co.jp. I have a question about your patch. My ex-colleague Vinayak created same patch in 2017 [1], and he couldn't get commit because there are some reasons such as the patch couldn't handle analyzing Foreign table. Therefore, I wonder whether your patch is able to do that or not. However, actually, I think it's okay because the feature is useful for DBAs, even if your patch can't handle Foreign table. I'll review your patch in this week. :) [1] ANALYZE command progress checker https://www.postgresql.org/message-id/flat/968b4eda-2417-8b7b-d468-71643cf088b6%40openscg.com#574488592fcc9708c38fa44b0dae9006 Regards, Tatsuro Yamada