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 1oTFTl-00029r-5O for pgsql-hackers@arkaria.postgresql.org; Wed, 31 Aug 2022 04:37: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 1oTFTj-00079O-RT for pgsql-hackers@arkaria.postgresql.org; Wed, 31 Aug 2022 04:37:27 +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 1oTFTj-00079F-Dz for pgsql-hackers@lists.postgresql.org; Wed, 31 Aug 2022 04:37:27 +0000 Received: from mail-pl1-x633.google.com ([2607:f8b0:4864:20::633]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oTFTg-0007Rs-VP for pgsql-hackers@lists.postgresql.org; Wed, 31 Aug 2022 04:37:26 +0000 Received: by mail-pl1-x633.google.com with SMTP id j5so9195111plj.5 for ; Tue, 30 Aug 2022 21:37:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20210112.gappssmtp.com; s=20210112; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc; bh=8VTGLbZsCO+1vFq/fC1ZE/noXfWAs9fWvsN+rzanjfg=; b=cZxNRQBp6IlRB7lIhkEHhVXbPkb4cqPreWQhqt8rVEiDL1Dmk/ioIzn3wWeKpCH2YG HAPSTyoN4j1TeJl3FWDYtFL9XsJbY2Ul6Ud4U3PuI8t4ySPWCDDLeCmnFaqI7KrdXDqc TkNDH+PWL8dnKmnp7dqqHwTKPG07rc4Ke1DzgDq5RqM/ZAPWvBcPZP2lxIlkm8kS6J9E OM3ZGhqwH814ztt/GXCwLmtBbeuVyocHUfRz2xlLCdCKHHnFwforz45fwcFi8nxL/yXf fMd40b1Z3I3ZgNSEilqkr2CeMnt4q6rSC86OSXJG4pzP3Vy4zwphqZanhZdzbDwm4ELD giYg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc; bh=8VTGLbZsCO+1vFq/fC1ZE/noXfWAs9fWvsN+rzanjfg=; b=rlusk9vG8U+31DnQpFWEWRXR9CUROtdVGUNBDNWiPlmRZ/C/acApPgcw5X1g6Rwo0k ZUB6YhTVlHvR8QzEV1ImvG23oKwpHhk9+WjLI8GJiZcBU6mWpeWukBJovYMToNR+MiDb NQ75+0emduSt5mHJDqj1DXez+lmttrLjxN1331AIu28JOoiB17veaJ/vbTfKClUhMf5u uztCpvUnVm2F3zMGhVzVzAjO5hIklFn9O3kSnlJCWx1TcdXaG8Ub2/QBTiAaogjd96D0 sILmuPkgWEGuSIfHXPLR9+iQ38FDg7GhUURgu2t9nZoD1VWh78AKZYEG+Ama2ag/islX UC2g== X-Gm-Message-State: ACgBeo04GcsSN+bPANTJv95jf45IzgryfljILW5jvdN9NHK8aTVHvznD D+nQv9UFShcNzuM5uhqK5n0TDg== X-Google-Smtp-Source: AA6agR5BB4oyL2xx42p3JfofCFj0z3gHTajYzYQnhyoQWnw785XdHvq1acXjgo2cZCfR/IwlMI81/g== X-Received: by 2002:a17:902:d591:b0:172:689f:1059 with SMTP id k17-20020a170902d59100b00172689f1059mr24404827plh.121.1661920642429; Tue, 30 Aug 2022 21:37:22 -0700 (PDT) Received: from jeff-laptop.lan (c-73-231-146-4.hsd1.ca.comcast.net. [73.231.146.4]) by smtp.gmail.com with ESMTPSA id j6-20020a170902da8600b00174d9bbeda4sm5092280plx.197.2022.08.30.21.37.21 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 30 Aug 2022 21:37:21 -0700 (PDT) Message-ID: <362d363097166e516f2d9ede5fbd4692ddb9235d.camel@j-davis.com> Subject: Re: New strategies for freezing, advancing relfrozenxid early From: Jeff Davis To: Peter Geoghegan Cc: PostgreSQL Hackers Date: Tue, 30 Aug 2022 21:37:20 -0700 In-Reply-To: References: <1892cc797f86924e31f00fd3c703ca464936c65e.camel@j-davis.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.1-0ubuntu1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 2022-08-30 at 18:50 -0700, Peter Geoghegan wrote: > Since VM snapshots are immutable, it should be relatively > easy to have the implementation make its final decision on skipping > only *after* lazy_scan_heap() returns. I like this idea. Regards, Jeff Davis