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 1vjExU-00BgkE-11 for pgsql-hackers@arkaria.postgresql.org; Fri, 23 Jan 2026 11:04:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vjExS-00HHNe-1I for pgsql-hackers@arkaria.postgresql.org; Fri, 23 Jan 2026 11:04:06 +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 1vjExS-00HHND-01 for pgsql-hackers@lists.postgresql.org; Fri, 23 Jan 2026 11:04:06 +0000 Received: from mail-qt1-x82e.google.com ([2607:f8b0:4864:20::82e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vjExQ-000000004aa-0Kj2 for pgsql-hackers@postgresql.org; Fri, 23 Jan 2026 11:04:06 +0000 Received: by mail-qt1-x82e.google.com with SMTP id d75a77b69052e-501502318b1so22374921cf.3 for ; Fri, 23 Jan 2026 03:04:03 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1769166242; cv=none; d=google.com; s=arc-20240605; b=Y30X7AOcd2hj5EVjJnsacGtfUsY4q4ggREA5kZ8XmXy8HdbW+Kkyl+OWEZugl+CAt/ 17Z0N08qgh3hTQPMaFq/6c5Q4vJbfaYfTTCGaMySjbjKTjL6SZi+wSqfp8vhj4wfiPtr BQvmWVgmMtI6YsLNdHdZX0gXLmvYgPV5Mc1xRrHrLTzFp6E8j+9ekMXpeQurWm2sCsdj 81Dya2TkWUnsfQpFJ/xn+d5GLfjsDRvMIa13q7diyLn40SKb0FOvcO7nGW1rd8bgyefb 9iyrLHR/JQ1h9YQbBTYw74R2g5ukX2OwEqglyafpgjG8tuKIxAQUO4ogSMFhwYvGkpW/ Yw7w== 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=1x5uqYbxAiOAUI/585v7sTUQRRi2ZoW68Q4YBY9B5YQ=; fh=G5cGxfjYRvVCYwt6Qb8HYs4xDLOpdgq2Vs3d+wUxfwU=; b=dVZ7CLK1lSc7GxwV1fi4JoHUN7fA13C2Q5Gy88ht1pnd3IXU29DQkSERpT1aVavDQB ENRxwy4yx/GB2qpizPbteT9MO+3ny6sWOmAkmx8n4i9wajJ/Ny707T6ui2oP85E+UNxd WnrsBXFAQGqB3luf6wQAtw1VG5mPKpUCiuazeRfYXPoDWKAHJzxuNowABgmtKO7GoN5B xnEdNQpnzCekt73jJecvVwnDNNMyAHMWSCdXQJ5koRoHW0/VY0OJPk7llrY+znEx6oPW guIz0HlMDt5yPhmGWAyHA2g+x8wM6dXn+iGXddbC55LxYHldUUPxMSaXoEdAdAhDcvC5 bTrA==; 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=1769166242; x=1769771042; 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=1x5uqYbxAiOAUI/585v7sTUQRRi2ZoW68Q4YBY9B5YQ=; b=Ht21vThFRhumYsnp87r9Q8w7fEMkmy3bU2d4HYUHDa9eJ/wKoBM+MQpWneTPmsdGw1 +/pt68yz1Yy9qjtjd0z71vyFK+ImM6nWuH8Kr0Fs0a3aOwk3CmLio4anydJ2eJIZ3m2U SJ/z+7SKS4CFFH7yygRu9P2a8pyiyCZGHZPV4dvjq6AMTAa8pHqalrW20VWyU6IQ4xVE 4Nk8y81QL4PKQcAXPUnuE99TX0wGE6dk7/JxG/EWbLIiVBgsfZVuM3hfqJ6dGghCaXOd 3g7HNuwJrSQAvGRhM6uz41lxLNYWzn+qHs2bKh/s6iXdF05wcDg6RZ9g5Lh6SZMgjcTi Lq1w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1769166242; x=1769771042; 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=1x5uqYbxAiOAUI/585v7sTUQRRi2ZoW68Q4YBY9B5YQ=; b=ZKSvwOQKc8oGPpQXU9SveXwfPGlmU9/m7Voi71Ro1kBZVR81R0FvSKbtbsVg3y6P0s lQAdCxUO/J3B+QAL68HijkLY7HTm07XbxheXDDFs57zh6lnO1fNRhyNQR71ri9zD4Q3s hi726o/o9Es2I86UsqIkF1sEyWS4FzyQnGxsIRYq6rKNx4tOnHl3oQi2G17Slh8jxDBU bU0vXfvd5lrseIPxEzlGLo82y4GGvV3Jp1xWIxELPwy6wxgO5ZPt3KBYjyo39EUvx7V3 sJEg1LKgPpqnfGJWqr7Ppy0UDi3TWOGOM8Fh/9cUPbly73viA2ukKxCLJWhnuSVPJDpV YxQQ== X-Gm-Message-State: AOJu0YyV4z9bBZ14NSJD/mYEiNsuCUBVF/HSIRaebYCIe8o28h06xVyB F79KKDiLEHBdFtBUJR5BAexgd/OWcec6qNZINhZiHQke1TbmvSk0l0MeLbh4F/P4tRFwqUR2qy2 cJKtg7/TTF1nClroNn0gT54aVpWfYm0U= X-Gm-Gg: AZuq6aIlieDTVNTx7FOsq9vLHX/evsW/vD8SrDFh8Q9tkGntr3hCqGdhnNfGiv7ZwSV UNtR3JxpjCiNE0Szmzd2TkBVRdEDjb8hb4q6EE41oINtR7SGc9nLtduj4HnSbakvyZmnS8BzF17 DuczbJ5wkG/7GMm3oxR6Ec+k7p1kTHpXenSbEaOPmn/rVqI6/+BjbkBAsKvnM5qvsY1JxXhZZav 1kcETyyf13tzH1ojBi1r4SBgYu49PSTfkSPGGGHVBjOSEpqon8L2jOULHkWM/lTVU4MRdE7lGlS iar7lBNEHrrcM/8hXFIXpOTviers0tFVKZNUjOHSvbMtTPRQbr5lzV3uCZnH7WvUZbKixQ== X-Received: by 2002:ac8:59d4:0:b0:4ff:c5f7:f812 with SMTP id d75a77b69052e-502f77c174bmr37821661cf.38.1769166242119; Fri, 23 Jan 2026 03:04:02 -0800 (PST) MIME-Version: 1.0 References: <449DFC8A-CF54-493E-9366-AF9C73C782AA@yandex-team.ru> In-Reply-To: <449DFC8A-CF54-493E-9366-AF9C73C782AA@yandex-team.ru> From: Kirill Reshke Date: Fri, 23 Jan 2026 16:03:50 +0500 X-Gm-Features: AZwV_QgZGGZNe0krEgTuEaJ_Dc-b8u2xCTn3ANldPX5-MR_foZ0NyOUxsceiOaY Message-ID: Subject: Re: Fix gistkillitems & add regression test to microvacuum To: Andrey Borodin Cc: pgsql-hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 20 Jan 2026 at 15:30, Andrey Borodin wrote: > > > > > On 15 Jan 2026, at 22:59, Kirill Reshke wrote: > > > > PFA v2 which leaves the test in-place. > > > > Also commit message improvements. > > Yeah, killtuples for GiST root page is broken. Your patch is fixing it. > I don't think we should backpatch this, the bug is harmless, but for master the patch LGTM. Thank you > It would be good to assign so->curBlkno and so->curBlkno together. But gistScanPage() is the only place with access to the block number. Sorry, didnt get this take. > +# Test gist, but with fewer rows - that killitems used to be buggy. > > Probably, in this comment we can explicitly say that killitems was buggy, but now is fixed. > Hmm, what would be a good wording here? -- Best regards, Kirill Reshke