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 1pgR3E-0008Kl-0P for pgsql-hackers@arkaria.postgresql.org; Sun, 26 Mar 2023 14:08: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 1pgR3B-0002R6-73 for pgsql-hackers@arkaria.postgresql.org; Sun, 26 Mar 2023 14:08:49 +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 1pgR3A-0002Qw-O3 for pgsql-hackers@lists.postgresql.org; Sun, 26 Mar 2023 14:08:48 +0000 Received: from mail-il1-x133.google.com ([2607:f8b0:4864:20::133]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pgR36-0006y2-PZ for pgsql-hackers@lists.postgresql.org; Sun, 26 Mar 2023 14:08:48 +0000 Received: by mail-il1-x133.google.com with SMTP id h5so3344331ile.13 for ; Sun, 26 Mar 2023 07:08:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; t=1679839723; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=b/xNbRtgOckPkaeSrfWsB/hemMy7ttykAf116vEjNL0=; b=KhOoHRRMQe7o5EfZFU4ZMJPhMi4HcSzcPGUVBGB8lxjJzmXNewcfMX5WEuvI16GuzZ zq0kUJlZ9cXZdkw9PTtgf/OZpG8neTF/DAd0PBPk+up9zMdw4rqi2mhuCmfcVbnpV92w AyqdWpb9PbXn/kTDhsuFy7qmnEVq3JHhgkNdCm/GW9ag7uIOGn6WH7AqwZjqEtpJ2THQ 2C0oSC5admr17thaT3wjDyAflhkvOPAD9HwjpPgdl7DoyZLMulEWrcxjy3BUym1DieTo tHx71HjO4tcciep52MHhL+pWG7zAlnNsrBltK2hybqOPHe78RwJIxzuNrNi9Paktsw9/ 0Vvg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1679839723; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=b/xNbRtgOckPkaeSrfWsB/hemMy7ttykAf116vEjNL0=; b=DnLR0h0PQ5zg6eco6J1UltQFuDayhfo2TP+3nefxTUJ0GkoyxG2U6R3okyEN+9bAzQ SmCZd5OJaQEkhd5Ek0BK57So3tb93z5E+Z4cj9kFnzn5S6A2EG057Xt0fQj8KoQexiYL WU1J/7HT4vrPO6rA59NWB5JaVE9udHRJ1bbRxwSYpqcKDlssSgCLzs1gBdulcYdOl6wD KOmMoV4xAwOW0CSs0yT9xVlsSXhE0kzzYRwJw+RbKlSZjGmnPpKoD8LVg1mhMDh9pB4d IW+CMsh54JXAAMSnuJ9I5iSiQINrnj6G5O3//l9GJRKjXQT0sk9pMHxoEk40kMRRYZyR X3aA== X-Gm-Message-State: AAQBX9fjDmMFCe35x1F3DtUu39KDOJeuGhRoPFa3otIJbp5updOlDIJp nXwHCkJWy9Axf7bwcmz//uO8iw== X-Google-Smtp-Source: AKy350a20pnSchz0glTQY3Hdb2xHXmh0KZxbWdH0SaGyKtVH4lEOv/9B2ljbS6RVoV7RdJBWuLD6Mw== X-Received: by 2002:a05:6e02:10d:b0:319:2bf:54ad with SMTP id t13-20020a056e02010d00b0031902bf54admr7182518ilm.14.1679839723002; Sun, 26 Mar 2023 07:08:43 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id p9-20020a056e02104900b00325c21a9e44sm3183032ilj.13.2023.03.26.07.08.42 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 26 Mar 2023 07:08:42 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 8E8ED80074A; Sun, 26 Mar 2023 09:08:41 -0500 (CDT) Date: Sun, 26 Mar 2023 09:08:41 -0500 From: Justin Pryzby To: Tom Lane Cc: Ilya Gladyshev , Matthias van de Meent , Alvaro Herrera , Tomas Vondra , pgsql-hackers@lists.postgresql.org Subject: Re: Progress report of CREATE INDEX for nested partitioned tables Message-ID: References: <34FE3024-5025-46B7-B435-8DDD59072705@gmail.com> <266AAEDA-786B-4DDB-B115-AE8EF0E5F283@gmail.com> <2003807.1679603746@sss.pgh.pa.us> <2586913.1679759713@sss.pgh.pa.us> <2614195.1679764277@sss.pgh.pa.us> <2773247.1679773412@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <2773247.1679773412@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, Mar 25, 2023 at 03:43:32PM -0400, Tom Lane wrote: > I pushed 0001 with some cosmetic changes (for instance, trying to > make the style of the doc entries for partitions_total/partitions_done > match the rest of their table). Thanks. > I'm not touching 0002 or 0003, because I think they're fundamentally > a bad idea. Progress reporting is inherently inexact, because it's Nobody could disagree that it's inexact. The assertions are for minimal sanity tests and consistency. Like if "total" is set multiple times (as in this patch), or if a progress value goes backwards. Anyway the assertions exposed two other issues that would need to be fixed before the assertions themselves could be proposed. -- Justin