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 1kNWJu-0004U5-4c for pgsql-hackers@arkaria.postgresql.org; Wed, 30 Sep 2020 07:14:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kNWJt-00048f-1P for pgsql-hackers@arkaria.postgresql.org; Wed, 30 Sep 2020 07:14:33 +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 1kNWJs-00044R-IH for pgsql-hackers@lists.postgresql.org; Wed, 30 Sep 2020 07:14:32 +0000 Received: from mail-pj1-x102c.google.com ([2607:f8b0:4864:20::102c]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kNWJq-0007nf-5N for pgsql-hackers@postgresql.org; Wed, 30 Sep 2020 07:14:31 +0000 Received: by mail-pj1-x102c.google.com with SMTP id jw11so394729pjb.0 for ; Wed, 30 Sep 2020 00:14:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=yzSPnHZ+NpZLNoJi1hqd9n5d4YTtsQ3SnglWrGYM6RI=; b=a4iXtWSdKSrCz3KcZwBm9urOt+jbEqx0YPTViJHz2BtOX+lXsUovMLwngkbe0bRYMP DtLyhk2SKpY+hr0StMFrvMoQloDnS7uAQ7y/bE21HGIy/5vvp3bn/T4hgtrZMTn7GwtV bys2Aoc2SogvVsPeAF6arIrDk95SImu2dwLKQ= 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=yzSPnHZ+NpZLNoJi1hqd9n5d4YTtsQ3SnglWrGYM6RI=; b=GLIB0uV2zFzWLe1pfhdM8HMDOo0JvveFgekEI9cXzjtSSYk1eJnzzrHB24G8ET74oN QuvMTCvDFOTF/FVNwxnR1vd5tSadHH7vhfbP+doOBGhTWA/Uv8HBHb3ntD8jIW0hcpKC WfWUgooXowFYxKE6uBxiaoPkvxP6uujDaFj668wat7gF3Mq2sP+4fLb2tOJFxXlMt/Zw hFPjuYzrpWIBY+OpqUDtmWegA047eaWuXteIVHWIDVWWpuz7M4T2ODFmvKgxlFwWUqnY QRYtZAhRa9uSudvZh+wpwwU35oHM5loyGHG2wMjBdL6nBE34imNNne587MXZr6VGObPs n4iw== X-Gm-Message-State: AOAM531M7XAiGuD7nSAcfnY/zlDD5qRNAEZl1149YjI+zzgXkMsy8mor NavYrL1NpF1JFJwAJ+CYcjmLSA== X-Google-Smtp-Source: ABdhPJzI2MvA4qaCAiMaodYhGBjunQTFxHF5Twg/eTS4+hUIYFQwqNJhdVdGihZcXGFLZ/n66+efwQ== X-Received: by 2002:a17:90a:d514:: with SMTP id t20mr1264532pju.134.1601450068947; Wed, 30 Sep 2020 00:14:28 -0700 (PDT) Received: from rfd.leadboat.com ([2600:1702:a20:5750::43]) by smtp.gmail.com with ESMTPSA id i9sm1234107pfq.53.2020.09.30.00.14.27 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Wed, 30 Sep 2020 00:14:28 -0700 (PDT) Date: Wed, 30 Sep 2020 00:14:26 -0700 From: Noah Misch To: Michael Paquier Cc: Tom Lane , Tomas Vondra , pgsql-hackers@postgresql.org Subject: Re: Spurious "apparent wraparound" via SimpleLruTruncate() rounding Message-ID: <20200930071426.GA1154112@rfd.leadboat.com> References: <20200322083452.GB1918808@rfd.leadboat.com> <13116.1585168951@sss.pgh.pa.us> <20200330052809.GB2324620@rfd.leadboat.com> <1959.1586198769@sss.pgh.pa.us> <20200407041847.GA519993@rfd.leadboat.com> <20200525070033.GA1591335@rfd.leadboat.com> <20200830053433.GA3275593@rfd.leadboat.com> <20200907020612.GD2455@paquier.xyz> <20200907031421.GA3595322@rfd.leadboat.com> <20200930060640.GB1996@paquier.xyz> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20200930060640.GB1996@paquier.xyz> User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Wed, Sep 30, 2020 at 03:06:40PM +0900, Michael Paquier wrote: > On Sun, Sep 06, 2020 at 08:14:21PM -0700, Noah Misch wrote: > > http://cfbot.cputube.org/patch_29_2026.log applies the two patches in the > > wrong order. For this CF entry, ignore it. > > OK, thanks. This is a bug fix, so I have moved that to the next CF > for now. Noah, would you prefer more reviews or are you confident > enough to move on with this issue? The former. I plan to wait until a review puts this in Ready for Committer. I'd be content if someone reviews the slru-truncate-modulo patch and disclaims knowledge of the slru-truncate-insurance patch; I would then abandon the latter patch. I'm not fond of how the latter turned out, particularly the unintended consequence in TruncateMultiXact(). (See the commit message and/or the edit to the comment in TruncateMultiXact().) The subtle interaction with SerialAdd() is not great, either.