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 1kOH8h-0006Wy-KQ for pgsql-hackers@arkaria.postgresql.org; Fri, 02 Oct 2020 09:14:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kOH8g-0002Fc-Ix for pgsql-hackers@arkaria.postgresql.org; Fri, 02 Oct 2020 09:14:06 +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 1kOH8g-0002FV-7w for pgsql-hackers@lists.postgresql.org; Fri, 02 Oct 2020 09:14:06 +0000 Received: from mail-il1-x12d.google.com ([2607:f8b0:4864:20::12d]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kOH8Y-0002W4-TD for pgsql-hackers@postgresql.org; Fri, 02 Oct 2020 09:14:05 +0000 Received: by mail-il1-x12d.google.com with SMTP id t12so637099ilh.3 for ; Fri, 02 Oct 2020 02:13:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=tflPppHTWILaH/O831uk9OalYh8LMhKJnVI5DJpsR1M=; b=2SCEm1Cl+Yg+sc4vuor9TkNO1F+Vw3P+SLSJmGV+1XWlERxrbyAN9mnUDcVZXCq2+n PH/lT1UgYIY5EdaXDvv8vqAD+NDrs86KtIHV2kqpmhZO5FdOTiTzuUAqw4gJHt10RJh4 7IQEWGzPJKKexp9tK0o1zGfT4yoO7NnOy4XBp8ogKvcRpgN4avQf0t21qnFy4W28vmzX 5DcfdcVnWFx4W1Zabk+pz+Rj9N1b2D85Pl3J51NciLTp+7slrlt8AdBfs7kbeprOP9HN W9kCBRA7h1Stqu93hUDsj6Z4LbaB+Cl0/gguUU9+BZDOifyBaRyrdLqAjCD/tXXU+MFs LaxA== 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:references :mime-version:content-disposition:in-reply-to:user-agent; bh=tflPppHTWILaH/O831uk9OalYh8LMhKJnVI5DJpsR1M=; b=tjhbdtJ2vSuQs+xL49uatspSsQ84fd+QqOqMMGO7xvpJlKlvFSjV47HEOFcDyquYrN kMfFqDQWVBUBs56UjQJTeAKTki/AkU1lXFSwVBWFchaMZVfO/aZsL1rbX5bDfc/CwE11 vbomClhM0otkI2ABRA3EXczKA6R7uDfiFP0gOu8WtAZsGY95Q/SMbYnXQtPpAlH02W1m iD4iTMddhiFeF7tGtTswZ8F33E5HrMSy9VhSKeJnCqSRzMtNhHWVH2JZysgVsPK55bWa hLYMQ5DkyCYZfNnZY5qf2g5yC+Awh0GSmFMRqDF/JqeI1DWmu2olpOEqIYS8Y3H+8v5w FL0g== X-Gm-Message-State: AOAM533SsAtnmLwtgKI/pyChIn/8QKTPfWZcLJ7yv5HP6amNpTpMZz/a VFTPuMCNvotqch68seSYu7Fg5Q== X-Google-Smtp-Source: ABdhPJwCda8AO0d82RcZtLrixi6mRDi3tK5Q1k4Xhi3UJfNjTgbm/NgtOK6KlpazMTFb+M/Pev3c6w== X-Received: by 2002:a92:dc03:: with SMTP id t3mr994366iln.245.1601630036958; Fri, 02 Oct 2020 02:13:56 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id o13sm436343ilk.40.2020.10.02.02.13.55 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Fri, 02 Oct 2020 02:13:56 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 1774D800581; Fri, 2 Oct 2020 04:13:55 -0500 (CDT) Date: Fri, 2 Oct 2020 04:13:54 -0500 From: Justin Pryzby To: Michael Paquier Cc: k.jamison@fujitsu.com, pgsql-hackers@postgresql.org Subject: Re: please update ps display for recovery checkpoint Message-ID: <20201002091354.GH8476@telsasoft.com> References: <20200818225238.GP17022@telsasoft.com> <20200820080905.GA10353@paquier.xyz> <20200831065244.GB6555@paquier.xyz> <20200910020050.GB18552@telsasoft.com> <20200910043710.GD2743@paquier.xyz> <20200919160031.GC30557@telsasoft.com> <20201002072814.GE1464@paquier.xyz> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20201002072814.GE1464@paquier.xyz> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Fri, Oct 02, 2020 at 04:28:14PM +0900, Michael Paquier wrote: > > Related: I have always thought that this message meant "recovery will complete > > Real Soon", but I now understand it to mean "beginning the recovery checkpoint, > > which is flagged CHECKPOINT_IMMEDIATE" (and may take a long time). > > Yep. And at the end of crash recovery seconds feel like minutes. > > I agree that "checkpointer checkpoint" is not the best fit. Using > parenthesis would also be inconsistent with the other usages of this > API in the backend code. I think maybe I got the idea for parenthesis from these: src/backend/tcop/postgres.c: set_ps_display("idle in transaction (aborted)"); src/backend/postmaster/postmaster.c- if (port->remote_port[0] != '\0') src/backend/postmaster/postmaster.c- appendStringInfo(&ps_data, "(%s)", port->remote_port); > What about adding "running" then? This > would give "checkpointer running end-of-recovery checkpoint". What about one of these? "checkpointer: running end-of-recovery checkpoint" "checkpointer running: end-of-recovery checkpoint" Thanks for looking. -- Justin