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.96) (envelope-from ) id 1w3S19-001ELb-1f for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Mar 2026 05:03:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w3S16-004OkG-0l for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Mar 2026 05:03:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w3S15-004Ok6-35 for pgsql-hackers@lists.postgresql.org; Fri, 20 Mar 2026 05:03:24 +0000 Received: from mail-ed1-x532.google.com ([2a00:1450:4864:20::532]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w3S13-000000007jN-3Zdd for pgsql-hackers@postgresql.org; Fri, 20 Mar 2026 05:03:24 +0000 Received: by mail-ed1-x532.google.com with SMTP id 4fb4d7f45d1cf-65c0891f4e9so286124a12.1 for ; Thu, 19 Mar 2026 22:03:21 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773983001; cv=none; d=google.com; s=arc-20240605; b=UedpvoHqvx8voyQWHA724sBOOnbAZD/cnaFAHJsA/kzKscjJA1OJ6qvIH1pWe44KUq D2DHe7K5kN8WV4JdVlvgbLNChsg+5atxKLq66zQB+kyOFpFQ+e0PiVOBThYg5E0EdblF bOVwDNIbvZcS6hjN6VxFRJYMbViRtLtAF06P8YRjlpb2sT3IsPNg0AwwUyPpVdrE64wq YlqQoTgAQ/5gNgRQH/ptlhz29iMx3nSLmO+fmUv9vIrQtWhf3MxevqvAyHyhiY538exY Shh9dxheefIev3fax+6/yMggCjPPU8hWOXSGFxt+12fskdPMzY/jtLrxP8EmBTttTcYr r3XQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=LKJGtmS/l8CzkspzMBkT9SrXSl9wM/BWc8G7HbrhVy4=; fh=Kv+hfxb0qQ/Tjhgd4HYmqqXcmVQ04DUkFLFGychXTnY=; b=cSVjq3N0YNnOQ2QK9dj8Tm+51d4ebjJTKVmqmKXoPm+er2vKk6yKbvUWUb4nGgPKOB 2T6fMPagpcPxNJ4m/Ho+BeLnYQKRsYWFWGqLvFGMQth317GeZtFiVm8kU5thAWQwfYg6 9nKGQ6vDSnFCK1i/ogLfqhJWP8wCTSecLtinqQPHzVF4ouEV81qX6cr6FE1Ghu82T9K8 tPbuGMe6+t1axylUaESmJdzieayKcdh9LHf2bQJy392wt3HEM0MtOFavUBQ+W1eWwUoZ 2J1kAyeJpt+iaWD0eSCAqqTRYQTpDPZ2FVnAm7XjKNjKYUW2KXFehCzCuW+JiP9isHwG aNJg==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1773983001; x=1774587801; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=LKJGtmS/l8CzkspzMBkT9SrXSl9wM/BWc8G7HbrhVy4=; b=fWVOe6HyCVOmfAq7r3PtwD+pctuLQX3qW8W8zAO39h1xVmziG25RVu0w1NNN6KULRg +xZ9iQJLuGjoQRv86oQ76UQyMH+I4dcg3/dAiNlMO0PNDwejEXNumTWEW7vpPT2unYoD wCOQRynzIwJnXOfez+ZAVK9q3qCzqRnEb5f438FLBuh0gXYEKURYJSRzYKXSOR++Uvjr YuOXalVaevf0ZFoO18OZJNH99WesvqXfY/yUe7fbe8pWiI+2PIOJpfHibygWOPjqWw95 iq3TOfTY8jtPlAg4eX2NZyE1eQrB62RQGpEEcqIFwjmap6wIZBafQBHg6xGtRg6IEjFf /+hw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773983001; x=1774587801; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=LKJGtmS/l8CzkspzMBkT9SrXSl9wM/BWc8G7HbrhVy4=; b=VnW3XnnK2x6yQGxxH3kzufIKkthduVWK9ziQRePi+GZ4z1X2PI6g1nlBIZ4KJx14IM lgw6gJ1qTUWEKtGgU/S60Yqk+tLX+zZkgTEcXqai3X5YHj5FiG1qGLgXdWLPRGaDpqpn +hJIHPlyQ7U62rXO2KkXOOs8EnsU6zklODVFctEjn8IDsc98I5145sM9jurUAwD3Ez04 7FWnD5TJNDqHBcgo0EwXM97HrzOwuj24WbkvbRoRwAuc01o9g4QpQ3piJBg1lphUVqRE 9vJidbeOsdoznUSEzif2Hs8QdHfS545ty0f/xxLiZVgw+tFrRCB/sm+JUBM/Plwi5GKw VXqA== X-Forwarded-Encrypted: i=1; AJvYcCW3TNtK4q3pK20SHJwezQE+z2mgP3fWQV6Jcpms9LG2CqCo8D/wV5tQPCqPJXOGvb6CbxkTjmrHR5/crrHE@postgresql.org X-Gm-Message-State: AOJu0YxAG1urjr7Ai2kJRj43R9NRbuGuokZ7gACEs6zVwrTZESihQCyw DPYXPSodKRupwCYYljFGGGpCtXwi+lzL9ULmba5F+PugXK1YhWlS3QtuDiV/9rzwSVc/Rmzwiev Ip0Tk9nOqfuzd1RuM4NmQRc1XMvMdRc0= X-Gm-Gg: ATEYQzwkBFQWKXo3W4j0aEnb5LR756sgZxD8fT+qgBXQbk+EC7c9H4EqluLUd/iFX/2 sALZSRF3W4TIYfFoMgDoQPvqlRuVKmW0vxf2OweuDlNIUyKXzC9VcY/nG92nUDrnANeiS38PZzQ biX9/+AMATTiYlwDLRmoX7HV21dj9Km9FLVLgV9u/UYlfoCSUHYSrSFN17QyNEADSmXAObDsSOu 8zoVf32ikypFyaMFd/WBlamMGQ5f+H00vFGIVdDmIZ7OPBY0b9Vn5gTrCo3AmgemR9C50HnJhyn GdT4oA== X-Received: by 2002:a05:6402:2695:b0:668:2375:e359 with SMTP id 4fb4d7f45d1cf-668c99307a7mr1233517a12.21.1773983000966; Thu, 19 Mar 2026 22:03:20 -0700 (PDT) MIME-Version: 1.0 References: <3ca1e398-c787-47e9-9afc-8e298b94dac0@app.fastmail.com> In-Reply-To: From: Sami Imseih Date: Fri, 20 Mar 2026 00:03:10 -0500 X-Gm-Features: AaiRm53UCwr2_GjTMYKACN7CLi5gchyT3NRsjfAbnFYpF3BrAt-mn4rJlfoydcA Message-ID: Subject: Re: another autovacuum scheduling thread To: David Rowley Cc: Nathan Bossart , Greg Burd , Robert Haas , Robert Treat , Jeremy Schneider , pgsql-hackers Content-Type: multipart/alternative; boundary="0000000000009c39f1064d6d9a4a" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000009c39f1064d6d9a4a Content-Type: text/plain; charset="UTF-8" > > case, effective_xid_failsafe_age and effective_mxid_failsafe_age are > signed ints and default to 1.6 billion. There's just not enough > bit-space to divide them by any number much below 1.0 before they'll > wrap. > Of course. It Would not be safe to divide by < 1. Thanks! -- Sami --0000000000009c39f1064d6d9a4a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
case, effective_xid_failsafe_age and effective_mxid_failsa= fe_age are
signed ints and default to 1.6 billion. There's just not enough
bit-space to divide them by any number much below 1.0 before they'll wrap.

Of course. It Would not be safe to di= vide by < 1.

Thanks!= =C2=A0

-= -
Sami=C2=A0
--0000000000009c39f1064d6d9a4a--