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 1p5tde-0007GX-7L for pgsql-hackers@arkaria.postgresql.org; Thu, 15 Dec 2022 19:11:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p5tdb-0002tX-Nz for pgsql-hackers@arkaria.postgresql.org; Thu, 15 Dec 2022 19:11:23 +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 1p5tdb-0002tO-CJ for pgsql-hackers@lists.postgresql.org; Thu, 15 Dec 2022 19:11:23 +0000 Received: from mail-io1-xd2b.google.com ([2607:f8b0:4864:20::d2b]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p5tdV-0003oO-9h for pgsql-hackers@lists.postgresql.org; Thu, 15 Dec 2022 19:11:21 +0000 Received: by mail-io1-xd2b.google.com with SMTP id r72so122153iod.5 for ; Thu, 15 Dec 2022 11:11:17 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=user-agent: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=vMYvEs5i3eaV9m4EfRDybrP/a5A4d6IPrO9o5k+XZIE=; b=dIe1QD21n/5lg3FV1x9qRFa0esSr16LmNF/EQxRC2wazsQyUEFcIaqgPhRlqH4tPQk ISt2/Nnbiat4kPNVNHm+GlSl/oxK4HGhfC0jrqiDr8IbEW1DGDEVYhosMvAX58tf6i71 R1no8C6anNSeqyXyArxfRhIVzeQHWkDRYzsujbjqtij5idxFkGKQApmEgHfXwNf2QyWD kXgczQy58DbhQ7qrlsacbU0rH8r07eXo2YgouyXAvbdh395b3HkAn3ifIsOhyhiRaAql RMSziUMxBEEhBxd/hBPJSDxYGKXj/G/5Q2ruFPz4IXOgUKLJ7tT02NtDbxpwOFnXu+CL i/0Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=user-agent: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=vMYvEs5i3eaV9m4EfRDybrP/a5A4d6IPrO9o5k+XZIE=; b=SBDp70XMaNhTj24DkL1Em54dwdPodeTYFsC+KS1xYblL7D6pCstCgbfTakUVwxBbzG mT80JE4P5RuTocbvT98uDYfbvfrWjwuA11nWmh9VtKK7ISqlgwW1Q1uXeZFSFROjgwpy +DxTU6ApWBWLNNhtuzbxDq+mYIOTCU191MFZfgQBJfIK90oLJT3AhhZuAvAmiegT4ye9 JntOsyDEuzwNPH8/kQ2mlHCGUNdSxQBoMbSjnYwNw2cYUdy0i30OvK56Gbof/+oh28Y4 R8hymJB0SXMDQzF/9iPCehjuK+snkUqGYHSp4ytYRorz4yU/FFO7ZXgXhPsPNCe3tND7 JfBQ== X-Gm-Message-State: ANoB5pkr5VBuC1CZmw1FqdZARQAbKsVkdL2qP9j9pbhx6sM/lpWDVOQG S5Idk1SNERepOKqFPIDHtxex5A== X-Google-Smtp-Source: AA0mqf4/6XbL/lN2jB/litxHcn5G/PToaZMY1/ZFyV5PYo40OGS2uH2ORqLfqdpNhNA26E9VPcsVZw== X-Received: by 2002:a6b:650a:0:b0:6e3:1cfe:3c9 with SMTP id z10-20020a6b650a000000b006e31cfe03c9mr7190462iob.8.1671131476106; Thu, 15 Dec 2022 11:11:16 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id b27-20020a056638389b00b0038aa3699c9fsm48214jav.95.2022.12.15.11.11.15 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 15 Dec 2022 11:11:15 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 88719800665; Thu, 15 Dec 2022 13:11:14 -0600 (CST) Date: Thu, 15 Dec 2022 13:11:14 -0600 From: Justin Pryzby To: Peter Geoghegan Cc: Andres Freund , Jeff Davis , pgsql-hackers@lists.postgresql.org Subject: Re: New strategies for freezing, advancing relfrozenxid early Message-ID: <20221215191114.GJ1153@telsasoft.com> References: <20221111034455.GE16809@telsasoft.com> <20221116052023.xg7pwgvx2t3hrgaj@awork3.anarazel.de> <20221206184255.dphhpvsyovqqwfdd@awork3.anarazel.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: 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 The patches (003 and 005) are missing a word should use to decide whether to its eager freezing strategy. On the wiki, missing a word: builds on related added