Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1svP8S-00Emkz-RW for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Sep 2024 22:44:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1svP7U-006vKD-4H for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Sep 2024 22:43:56 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1svP7T-006vK5-Qm for pgsql-hackers@lists.postgresql.org; Mon, 30 Sep 2024 22:43:55 +0000 Received: from mail-wm1-x32c.google.com ([2a00:1450:4864:20::32c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1svP7Q-001rLl-Uz for pgsql-hackers@lists.postgresql.org; Mon, 30 Sep 2024 22:43:54 +0000 Received: by mail-wm1-x32c.google.com with SMTP id 5b1f17b1804b1-42f6bec84b5so11900285e9.1 for ; Mon, 30 Sep 2024 15:43:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1727736231; x=1728341031; darn=lists.postgresql.org; h=user-agent:in-reply-to:content-disposition:mime-version:references :subject:cc:to:from:date:sender:message-id:from:to:cc:subject:date :message-id:reply-to; bh=vZ3Nc/4aOspBE9ae3LY9JupWhVmVyJuYVhyAUE4svl0=; b=Lj575i5t4brnbVDPbsU23igHl0zZD0rwyzY3eLyA3tmBH/NOm9NsvzduIdb758yvpE VG/VtLT3BOORhOLDXElDEOQKYG8OLm1kWf01M382SeO8ff/Fw2X4DncZVu3aK6p81XoS 32XEGTlVgi/GKjSgEtJibGA03p69BOSDJd2i3TtCQJne44+vIbRnaQaC+PsPZ4OHJuxo vENlyuOrk8gZvrPyKUqZ5n1GzRQOHLko+0PVlWB02dBs7juU6KprsUYxWVD7qgi9Rzwc K08VcbSoQt9iSWrDOWsYtVfmt/24lj6u1LJaz+Zk8Cryj9BxuB0fWdYPRimJgLWi/jBJ BUDQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1727736231; x=1728341031; h=user-agent:in-reply-to:content-disposition:mime-version:references :subject:cc:to:from:date:sender:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=vZ3Nc/4aOspBE9ae3LY9JupWhVmVyJuYVhyAUE4svl0=; b=lzb8sJ7Cwxt6Q3pvy49cpSkocJPC3SBpja/nv6ZlwCLTstft7b5VHyeKWiaHwp2BEY 30HtkLD79CdMFFP4tBkHEG3D0ttuvO1dXQK8fMwQ7M2dCJLfX1WvE1Yb2ZLUdLcHAvXj POR2qZMs69MXeqf55+IosTEwAe3EgkypJophKln4/L6w/4KAaB4pVxJcvq/1Mh0x1lZN /oFr84M3moLMtHXogpKFx52eKBLeL0SLkWfmal7m3U5TX1LF6royHWwVlW38W004jiWS KRcaMz6+XUdZaaiLmviu3vW+16rUxBBO3pzK3JoJe7NlPd72JFi3sypjIeDdXzixCVmR W2kw== X-Forwarded-Encrypted: i=1; AJvYcCX/6mJwowGhhYMY56KZkeKHbmBNqXNVZ08TKa/zvMUKO/XoccSRvJH+woIoLdQtb5bpaUZ7re71xRplzv97@lists.postgresql.org X-Gm-Message-State: AOJu0Yw8cmu2fGxg9PlbAIpdAFrXW/cBZrFYMmaGbeGydE+IB8HfPaNP hvfMXvyyL3vMozs3r0FrpJALd7Gyn96A1IOUvJsSFbJtyAFxJIxntDVTsA== X-Google-Smtp-Source: AGHT+IGhIEHu6/juqlLzyfegwCouh2GArMog1MBodeSl52OHARyl9BeIoqN93M3HR5zmzDh8PJ2qZw== X-Received: by 2002:a05:600c:3c8f:b0:42c:b45d:4a7b with SMTP id 5b1f17b1804b1-42f6944175amr43183625e9.25.1727736231290; Mon, 30 Sep 2024 15:43:51 -0700 (PDT) Received: from lightning.caipicrew.dd-dns.de ([2001:a61:aeb:9601:de9f:ad50:75e5:2a8c]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-42f57e30621sm120519985e9.47.2024.09.30.15.43.49 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 30 Sep 2024 15:43:50 -0700 (PDT) Message-ID: <66fb29a6.050a0220.1c8f2f.8be8@mx.google.com> X-Google-Original-Message-ID: <20240930224349.GA10807@caipicrew.dd-dns.de;lightning.caipicrew.dd-dns.de> Sender: Michael Banck Received: from mbanck by lightning.caipicrew.dd-dns.de with local (Exim 4.92) (envelope-from ) id 1svP7N-0001Py-Bq; Tue, 01 Oct 2024 00:43:49 +0200 Date: Tue, 1 Oct 2024 00:43:49 +0200 From: Michael Banck To: Daniel Gustafsson Cc: Tomas Vondra , PostgreSQL Hackers Subject: Re: Changing the state of data checksums in a running cluster References: <801a7cc1-bc23-4253-9b98-a5700f30e98e@enterprisedb.com> <383DA36E-405C-430E-A677-DB045EA37142@yesql.se> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <383DA36E-405C-430E-A677-DB045EA37142@yesql.se> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Mon, Sep 30, 2024 at 11:21:30PM +0200, Daniel Gustafsson wrote: > > Yeah, I think a view like pg_stat_progress_checksums would work. > > Added in the attached version. It probably needs some polish (the docs for > sure do) but it's at least a start. Just a nitpick, but we call it data_checksums about everywhere, but the new view is called pg_stat_progress_datachecksums - I think pg_stat_progress_data_checksums would look better even if it gets quite long. Michael