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 1hkYE1-0002a3-H3 for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Jul 2019 18:18:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hkYDz-0008V1-Hv for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Jul 2019 18:18:51 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hkYDz-0008Mb-3g for pgsql-hackers@lists.postgresql.org; Mon, 08 Jul 2019 18:18:51 +0000 Received: from mail-qk1-x742.google.com ([2607:f8b0:4864:20::742]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hkYDw-0003EQ-LO for pgsql-hackers@lists.postgresql.org; Mon, 08 Jul 2019 18:18:49 +0000 Received: by mail-qk1-x742.google.com with SMTP id g18so14062195qkl.3 for ; Mon, 08 Jul 2019 11:18:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=Te+6ortH0tfrze+ZGbTt/p+/oPIo3l/Jwd1DjMbGMTE=; b=iNWztjkhwfce28xkF9gx78jJVk5QwI/758fmF+54ekYHsIrGGVY4SdukIXK22uguZH X8gwxKSKnT5iixmMUVoGO8fW1BEmYKNZ18t1EuvTuhMC+fiNKXjg1hgIGxNphGza2VsB fxkzxNIUAkWYSae1OL8OjrV5saY31q38+d/ennElZGpcFjsU0S7W+5ltAncrdACfgZyM OJ6kiYMM04XHb+orrkTlO/3zWzjAFB+SRN29VtMI1GAjzjOiUZE6qWNs07+I/Ypj5yj0 WzCergYBVyAG6iGCOyU9veH/R4P+umuLD2Kpu08Zk6Ge2y9mLuq0qhXTRoMaSR3q0ouh P7UQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=Te+6ortH0tfrze+ZGbTt/p+/oPIo3l/Jwd1DjMbGMTE=; b=ZUdv3JgE5Kw/avdMmnEPbdpkq2BJ26/eyMYlDxKcAySzEWxD/wMq6ez6thGK+Q+VTW ikOO5vGCmSgY9iM38ySim3FtjEEtdjGpgWBdFnz++qELCMZG+7EhpzebwLrsB8G54+Qb CzMrN2ACe1wjDL075nB71h+nRgpN4gDrtBJDev6yesimPHTNL1OiiR6z90nDJmtRg4aP 55JanbUtT+PurRbqA2ze1lCVUc8q+bM1fEdfKK4Py6mijT0xlAaaR+fSKIf3w+WovXzc kawPYFlWpFebeRRA9M29q/oFX79LVufDoyuYsz3hCoJO2x20jkvugZJ46bK/DK2CgAb3 ORuw== X-Gm-Message-State: APjAAAWCP7HxF/nwlgbHuro00DWqUoYeifLPhidft4CU2/VKM61dLAOb J5pzx5vO8ProYBHBMOfoKVf+zA== X-Google-Smtp-Source: APXvYqxH4ohSszNoyqPWBFkokybCs2gzpzWqo39rAuAAqNK5SvFb2JOarHd/Q9t0pfUrRWjeMGnrBA== X-Received: by 2002:a37:a44a:: with SMTP id n71mr13520795qke.393.1562609927867; Mon, 08 Jul 2019 11:18:47 -0700 (PDT) Received: from nimloth.alvh.no-ip.org ([190.121.29.3]) by smtp.gmail.com with ESMTPSA id d9sm4698611qke.136.2019.07.08.11.18.47 (version=TLS1_3 cipher=AEAD-AES256-GCM-SHA384 bits=256/256); Mon, 08 Jul 2019 11:18:47 -0700 (PDT) Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000) id A72AB124A5B; Mon, 8 Jul 2019 14:18:45 -0400 (-04) Date: Mon, 8 Jul 2019 14:18:45 -0400 From: Alvaro Herrera To: Robert Haas Cc: Tatsuro Yamada , PostgreSQL Hackers Subject: Re: progress report for ANALYZE Message-ID: <20190708181845.GA14186@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2019-Jul-08, Robert Haas wrote: > On Mon, Jul 8, 2019 at 5:29 AM Tatsuro Yamada > wrote: > > 17520|13599|postgres|16387|f|16387|scanning table|4425|4425 > > 17520|13599|postgres|16387|f|16387|analyzing sample|0|0 > > 17520|13599|postgres|16387|f|16387||0|0 <-- Is it Okay?? > > Why do we zero out the block numbers when we switch phases? The > CREATE INDEX progress reporting patch does that kind of thing too, and > it seems like poor behavior to me. Yeah, I got the impression that that was determined to be the desirable behavior, so I made it do that, but I'm not really happy about it either. We're not too late to change the CREATE INDEX behavior, but let's discuss what is it that we want. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services