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 1n2d6m-00013b-SY for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Dec 2021 17:51:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n2d6l-0004sb-Ne for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Dec 2021 17:51:27 +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 1n2d6l-0004rc-BC for pgsql-hackers@lists.postgresql.org; Wed, 29 Dec 2021 17:51:27 +0000 Received: from mail-il1-x12f.google.com ([2607:f8b0:4864:20::12f]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1n2d6i-0002bd-FS for pgsql-hackers@postgresql.org; Wed, 29 Dec 2021 17:51:26 +0000 Received: by mail-il1-x12f.google.com with SMTP id y16so17130041ilq.8 for ; Wed, 29 Dec 2021 09:51:24 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=CP/wJRDFEHdMT9itYHlPHyLyLsHreLkbanigMPPSxnQ=; b=Z6GauOg/BS5RUKllvwAczHkB6V7D9cjlCOaJSu+Eyu5TM485LYkmJjjwchJlWoof1C y1wqcYysAGXb1kouNuWhxtLO7CQVyVuFHKIUUKB4IOVeLDkhtdcMtgXCN1eCOC1KuQ4Y VMyjdol+Gyx3H/yPM9iUXFlkndqKBYNNgCGHjCXp/c96x5trzOTLg/9VqDKBkh/KeBZ0 wrB9YsHJOUMn5H2HSiEzmCSF15DXOgV7yvgWha5nYfssL4DBut+oC5nH5jofn4YaRSVd gXVHVvWDfwoNssbyWTzKyztuWb1+/2EUOb/s1paFdscTd89XRWa5UA/4Zukkfc/EtkO9 YQxw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=CP/wJRDFEHdMT9itYHlPHyLyLsHreLkbanigMPPSxnQ=; b=7nzOVoZ88xXxMeRUWGgkewbqjtNo6k4dDzH16qe/21TzSIngZCeoOEg/I8Zg/OSpX7 IZTIK77kyOnkI1utqAugFruYD7LYeGdJoVZ9duapRAJmy2zFmvr4++Fz9FuDzoNdiHHf dl15j6tMKSMwKSc8lxkOOcpF2LTB11s3tIYeC3rxY1b33ETEdetWHumO3brv8bfla2E/ Q4UreZKNamzbj0sN37mkhrYEDmbWsxbR1yGayHGuUXEcYnrzrobY+490FK9rPVhZ/les pBXTbemuKkoLBvUmgIaoY7nzh3fM5oGyZCYt2rT8vOs7BDtEaxjdJ60jtp5h3d4PONQR TvVw== X-Gm-Message-State: AOAM531oEHRKru2GRkY7glU24I7nnMlpmO7kHkxcWz3hKN5AfModl0fw uFEDXvip4QNcAKtGIyKDx7S4fw== X-Google-Smtp-Source: ABdhPJySECnkEnv87/GVk2OKCWg6Xyoz12bNTdprI+WOB+8AGP6m3jT8NCh8EpYyE1wZri0Bk3YcRA== X-Received: by 2002:a92:504:: with SMTP id q4mr11914330ile.126.1640800283463; Wed, 29 Dec 2021 09:51:23 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id m14sm14723653iow.54.2021.12.29.09.51.22 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Wed, 29 Dec 2021 09:51:22 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 73410800774; Wed, 29 Dec 2021 11:51:21 -0600 (CST) Date: Wed, 29 Dec 2021 11:51:21 -0600 From: Justin Pryzby To: "Imseih (AWS), Sami" Cc: Masahiko Sawada , Peter Geoghegan , "Bossart, Nathan" , pgsql-hackers@postgresql.org Subject: Re: Add index scan progress to pg_stat_progress_vacuum Message-ID: <20211229175121.GP24477@telsasoft.com> References: <5478DFCD-2333-401A-B2F0-0D186AB09228@amazon.com> <7874FB21-FAA5-49BD-8386-2866552656C7@amazon.com> <7F1C93C1-C50E-497A-86C5-B637EA4D9F79@amazon.com> <04D9F80C-1A7C-4C23-9156-6799D974DC72@amazon.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <04D9F80C-1A7C-4C23-9156-6799D974DC72@amazon.com> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk http://cfbot.cputube.org/sami-imseih.html You should run "make check" and update rules.out. You should also use make check-world - usually something like: make check-world -j4 >check-world.out 2>&1 ; echo ret $? > indrelid: The relid of the index currently being vacuumed I think it should be called indexrelid not indrelid, for consistency with pg_index. > S.param10 vacuum_cycle_ordinal_position, > S.param13 index_rows_vacuumed These should both say "AS" for consistency. system_views.sql is using tabs, but should use spaces for consistency. > #include "commands/progress.h" The postgres convention is to alphabetize the includes. > /* VACCUM operation's longest index scan cycle */ VACCUM => VACUUM Ultimately you'll also need to update the docs.