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 1ofltL-0005aD-W6 for pgsql-hackers@arkaria.postgresql.org; Tue, 04 Oct 2022 17:39:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ofltK-0008S9-QX for pgsql-hackers@arkaria.postgresql.org; Tue, 04 Oct 2022 17:39:38 +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 1ofltK-0008Rw-C3 for pgsql-hackers@lists.postgresql.org; Tue, 04 Oct 2022 17:39:38 +0000 Received: from mail-pf1-x429.google.com ([2607:f8b0:4864:20::429]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ofltH-0000fz-Tv for pgsql-hackers@lists.postgresql.org; Tue, 04 Oct 2022 17:39:37 +0000 Received: by mail-pf1-x429.google.com with SMTP id f140so8473532pfa.1 for ; Tue, 04 Oct 2022 10:39:35 -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:subject :date; bh=1ejE84NzkPguSvzJAuC/BBpayyOXBfkXXMC5IIq5p64=; b=o+1aOxxjKp7Qp6TOhXsBvjszNOoIGExnrAyAW35bWIlGuokOUhykLqSgQ12pIqWBAd /ZO0Vf9kWIbrOC0PskPNGwXnFpCtpn6SwJHYGSmOz4nN9eTJbYUObyCapdazR0N4Rihe TZgWuuhppXtkeAalY69pjMB76URHdwPovNDEl+cRwLpZifclLmmjfwuc7R1hzvNT9jfx X8jyrB/py75Ixu4U6RPAO9wOxu4NuiCEcIqMVPGvj0uusL36lrAENQbWzhHy4aOYVj9M V5PN2QVmm4hAvciPtUXmzQ3J8U1AzT8h2p+wwuaxyNdOidNUzjT2bojBW9U79yVu3MJP DUOw== 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:subject:date; bh=1ejE84NzkPguSvzJAuC/BBpayyOXBfkXXMC5IIq5p64=; b=nq4fuX6iHno//2ScMaQslX3rPe4FEmgvtRdlgB84NexZSpctj8/p3lbK3M04EM7B1c LaThGYwR8tgEWVhh16jMQCgI40eW9Jrqbs4TCBePGuB47nznxv9s7Iu9sZcE/UeZh7/N 4TvFOC7ooW2nd6mbTk6qav1AgjdNDxsoyybt17lgMQKkdsri7dt1TwFxSPsV1n6Yr1yu 8TfH1aIEFJnIETrT6mk6+z7rTVreHBGtbk1wDv0CBGHGlqA7KIjROUssrLYPl/HkVGF8 wEXjQkbX0wnd7/pP4y0xkmCEcczroUr4CXMYXat0ksI6D2hCJiwHjAkZZDAAJdd3ZgOI DBNw== X-Gm-Message-State: ACrzQf3iFPR1GyjlWD7XBYT9V6G4AfBZZrFXI1B1y6U7nNG0+8agr4RU V7Lq5HBliKfuI5ENS+q/375lCJ+IA1OioQ== X-Google-Smtp-Source: AMsMyM7RQK7ccsSmSTAOaNup85NZO90iqXjIIi4Lu5U5F7hb7BEzECWcl4phVoLEyopMPeZJE4Wo9Q== X-Received: by 2002:a65:4bc3:0:b0:439:103b:fc35 with SMTP id p3-20020a654bc3000000b00439103bfc35mr24214034pgr.248.1664905173569; Tue, 04 Oct 2022 10:39:33 -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 i16-20020a17090332d000b00176ba091cd3sm2616304plr.196.2022.10.04.10.39.32 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 04 Oct 2022 10:39:32 -0700 (PDT) Message-ID: <78aecdaa345ea8cb1554ff2dbc08eb0e2262130a.camel@j-davis.com> Subject: Re: New strategies for freezing, advancing relfrozenxid early From: Jeff Davis To: Peter Geoghegan Cc: PostgreSQL Hackers Date: Tue, 04 Oct 2022 10:39:31 -0700 In-Reply-To: References: <1892cc797f86924e31f00fd3c703ca464936c65e.camel@j-davis.com> <424877f4840495235b9be5cacc65a2b84d000566.camel@j-davis.com> <9bc85fb435df6f5fc2ececc00c0a086d41b755b4.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 Mon, 2022-10-03 at 22:45 -0700, Peter Geoghegan wrote: > Once a table becomes larger than vacuum_freeze_strategy_threshold, > VACUUM stops marking pages all-visible in the first place, > consistently marking them all-frozen instead. What are the trade-offs here? Why does it depend on table size? Regards, Jeff Davis