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 1h3QRb-0006rt-O6 for pgsql-hackers@arkaria.postgresql.org; Mon, 11 Mar 2019 19:18:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h3QRZ-0005n1-VQ for pgsql-hackers@arkaria.postgresql.org; Mon, 11 Mar 2019 19:18:37 +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 1h3QRZ-0005ji-LM for pgsql-hackers@lists.postgresql.org; Mon, 11 Mar 2019 19:18:37 +0000 Received: from mail-qk1-x742.google.com ([2607:f8b0:4864:20::742]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h3QRW-0003rG-Hy for pgsql-hackers@lists.postgresql.org; Mon, 11 Mar 2019 19:18:36 +0000 Received: by mail-qk1-x742.google.com with SMTP id z3so3432739qkf.5 for ; Mon, 11 Mar 2019 12:18:34 -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=+DfKS5P3TLxDhajZLejMYtUh51mzoV+BTCf6oMYUIcY=; b=zckF2bylB1u7SuayxYBTalywNndUZ9FkSEmCKgdxnJWv+UIZo4hOZ9tFU0EJEfQUxT zyuJinJLi8G0PtC6NXNTNmEQUQ18MyqJZhJYB2qKkQNSKbfvWRQxpbLV801ou4JHHxdQ rugBiw8w486hHmorm0GGyjO4feLFzNsVARV05P/ZOSlfg69cwoyi2KvcY8C3JBsnNS8T ggU8G0fjHJVQW8hMwdFhviYnP6+cGtllUXLmP5H3raPyjTI/X/TnPMQZWQLfGsp6I2Ub Gte1LDeRuBkBSzBMJ2C9MxSXYUMMNcN8GIhlZ2iILO+IFDPftGenEYFpGGMF6iVnW+rI PoWg== 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=+DfKS5P3TLxDhajZLejMYtUh51mzoV+BTCf6oMYUIcY=; b=hBkiWahyn+z4qpzEOK7qvEkVakhmWJ0Dl7T5QDG2gEKgdACzoXxUaRpUyfKFAguzsq UTSmz7HrkEQyEjLz6CadsAU7E6UEO8yXwgyOuh/ouKpwN+xNLndFT5j1ZhadtmE9/NHC AF1Cn4hT7VVxrvwvwgSY6No4K+c0F7s0J/6bv0nQW4CJnWM3nMicWPbBciKP5AH3vvr/ DTwj6iFNSQP1UDgRW3elofw5FQ0RCfumWA0ou8Wvji7zuWnaaYLkkVGGi2XInsnnfJRQ nC3TpVfebn3WTz6UuqDeW7sPDv2yjPFX4m66meuo3DTghSlNoDWAi/puv6IRhpqO+RqW t+DQ== X-Gm-Message-State: APjAAAUbLr136DJppQBQl/TXIVZCo4kd6f8nOYMFwMFvpToPtBs6o1Bx znkKKQYOjtnZ05UC7BwdCvE0Cw== X-Google-Smtp-Source: APXvYqwWqtHoFRZ2vflI89Oyrmn7/gfRToXC4laar2JnyrmdqU4sXzg/rLy0c/JfOM1BBQBA8mHwHw== X-Received: by 2002:a37:d64a:: with SMTP id t71mr5820350qki.183.1552331912808; Mon, 11 Mar 2019 12:18:32 -0700 (PDT) Received: from nimloth.alvh.no-ip.org ([190.121.29.3]) by smtp.gmail.com with ESMTPSA id s5sm3926603qkf.87.2019.03.11.12.18.32 (version=TLS1_2 cipher=ECDHE-RSA-CHACHA20-POLY1305 bits=256/256); Mon, 11 Mar 2019 12:18:32 -0700 (PDT) Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000) id E351D121DD2; Mon, 11 Mar 2019 16:18:29 -0300 (-03) Date: Mon, 11 Mar 2019 16:18:29 -0300 From: Alvaro Herrera To: Robert Haas Cc: Rahila Syed , PostgreSQL Hackers Subject: Re: monitoring CREATE INDEX [CONCURRENTLY] Message-ID: <20190311191829.GA30006@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-Mar-11, Robert Haas wrote: > I don't think that I much like this (3 of 8) and (2 of 5) stuff. It's > inconsistent with what we've got already and it doesn't add much. > Someone who wants to know which phase it is can look at the underlying > numbers directly instead of going through the view, but most people > probably won't care, and given that the phases may be of dramatically > unequal length, I don't think it's adding much. > > Another reason why I think this is a bad idea is that there may be > some operations where we don't transit all the phases in all cases; > the pending patch for CLUSTER progress reporting works like that. What part of it don't you like? Is it the fact that we have phase numbers in the phase name? Is it the fact that we count total phases? Is it that we have two numbers being current (phase + subphase)? -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services