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 1wmj93-000wTX-0F for pgsql-hackers@arkaria.postgresql.org; Thu, 23 Jul 2026 02:26:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wmj92-00EBsz-1s for pgsql-hackers@arkaria.postgresql.org; Thu, 23 Jul 2026 02:26:44 +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 1wmj92-00EBsr-0y for pgsql-hackers@lists.postgresql.org; Thu, 23 Jul 2026 02:26:43 +0000 Received: from mail-pl1-x634.google.com ([2607:f8b0:4864:20::634]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wmj8z-00000000ieO-3rIw for pgsql-hackers@lists.postgresql.org; Thu, 23 Jul 2026 02:26:43 +0000 Received: by mail-pl1-x634.google.com with SMTP id d9443c01a7336-2cab973140bso1921425ad.3 for ; Wed, 22 Jul 2026 19:26:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1784773599; x=1785378399; darn=lists.postgresql.org; h=content-transfer-encoding:mime-version:references:in-reply-to :message-id:date:subject:cc:to:from:from:to:cc:subject:date :message-id:reply-to:content-type; bh=YD4sASPGRKcm7ocl7bb6vk4ZhNmayKEVU4Jvg8I4XOk=; b=kGfxkEW1l4yvPvS6lbZHgr/CPz03+ER71sEzAWQSz0TCqY0JHz/8UthTs6ELcgfXPP jxGL/N9DVAIKkrQ9RPiJ/RmEh/2/D1OGhTQwioRtqn4eK2/vmhsx8egDbNKrLW5g2RCe WpL7isE5/fq2kH3G+oIYrvU7CP9eYNeJhd0auDyTGIXpQcb2/ZVYgyrt6rpnPNQnmCbs 2utFVPlcuwtbwoxYaaraTj4w4ji2XSYR4ZG141QJIZ3nJbTHApxqW+rg9OioyAyXUIYp SPCo+33cp7sSemLUy8N7MCRDLTE0LMmUtQ6unwmwDFIGYhr1t+VmYcSK+uA7vpMdYY8l 3Dsw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1784773599; x=1785378399; h=content-transfer-encoding:mime-version:references:in-reply-to :message-id:date:subject:cc:to:from:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to:content-type; bh=YD4sASPGRKcm7ocl7bb6vk4ZhNmayKEVU4Jvg8I4XOk=; b=QvyIdRrJ5QC1TpQTnkk00LCDzZfgYNNUyXFc5mGA4E1MgJpsflEK10CHPFts7THmRO KO7yyDfclv1dsl6rpDMOKQV1ezus5fGjSsiGsi9YJmSMInsap0y5FmDvp7SH1MdiMrXx KWgrh/VVIqP2EWb3Bb7li2QZ1tm/6qAEmzfYDL2mHLMENOtBHpqPZ/Akq0KfuaX4jXPa /T96uUPcP/Ybu56iDcQmIKCPfEd59BIZSwidHJRvyowN/kFY/eD5Y73N7QwXCFXi0vVi 2pMR0bg7EBpqeRz1GIV+SaKxoP6CeeWQc8uZGa/JbopxGdIjWsw+Zw3qWg1384X/Msb5 3tFA== X-Gm-Message-State: AOJu0YyFaElGXGURS8DHfokTUtahtWxGLQkhcD3ZC3lq+7ZHMhZrOSDB 63ZUCfeHrVqreVgXayRR4FzBkwuFAb3Emty7F9IKQs0cEhOSqcpf6VJiYwA/dODpRogQFQ== X-Gm-Gg: AR+sD11YuUJuXJABWo7IG4ZCMYFZnSUuHqRycKV+hac1oG0PLjHPtdvmnEdyPD9JcII 5zxLHug//YEh26hJXBaqMIZX19Jb8ijaD95RorvXtRhX4fB25VcZHmDygteBU+RYPr9xIlnC+WQ AQzpD7/n1pegx6ha0qXZn50ZRbOOTE4gbbhbfTkpnxG0YYEso1oSANhwrBxr5iNLoRzHE9EN3nx Xz3L09eoOnwVyiNzd8RmmEzP/fE5BjSW9MjS0Sm6ui3gjiv5YwEc0Z4UIhlwRDlovgCotOWLk0V ycO0GAEAfk7FSDg458A+QpMg36cR1paSdCdCR/eKViIkjni0fzabxw6TA6StVnfNEHZk2hM/olk 0WhL05oIkRW5C0GHxQ5Zwa6QdlAOdAW39ur3pfPrSA5YjHYmH3N31QXWIZMjQcSSj4sMStemX6R xol3KxOexG3Z95F3mgVKx9g9DhvnVk2IsUmuYyug== X-Received: by 2002:a17:902:d491:b0:2cc:d6de:d597 with SMTP id d9443c01a7336-2cfa6a59f25mr17012415ad.7.1784773599421; Wed, 22 Jul 2026 19:26:39 -0700 (PDT) Received: from localhost.localdomain ([61.98.119.142]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-2cf8efe3afbsm23443235ad.33.2026.07.22.19.26.37 (version=TLS1_3 cipher=TLS_CHACHA20_POLY1305_SHA256 bits=256/256); Wed, 22 Jul 2026 19:26:38 -0700 (PDT) From: Paul Kim To: pgsql-hackers@lists.postgresql.org Cc: aekorotkov@gmail.com, michael@paquier.xyz, x4mmm@yandex-team.ru, Paul Kim Subject: Re: Restore vacuum_delay_point() in GIN posting-tree leaf vacuum Date: Thu, 23 Jul 2026 11:26:35 +0900 Message-ID: <20260723022635.21756-1-mok03127@gmail.com> X-Mailer: git-send-email 2.50.1 In-Reply-To: References: <178447127453.110.12276981925360691905@mail.gmail.com> <33B92CF3-4BD1-40C0-91AA-D7F96D136730@yandex-team.ru> <61A36DCE-E555-4409-83E6-7232417F0B97@yandex-team.ru> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2026-07-22, Alexander Korotkov wrote: > Please, check the patch attached. Thanks, Alexander. The patch looks good to me -- it's the same change I posted upthread, and the placement is right: the call sits after the page has been unlocked and released, so no buffer content lock (nor any other LWLock) is held across the delay, matching the sibling loops in ginbulkdelete() and ginvacuumcleanup(). The added comment reads well. One note for the back-branches, since it's marked Backpatch-through: 14: vacuum_delay_point() only gained its bool argument in e5b0b0ce150 (v18), so on 14-17 the call would need to be the no-argument vacuum_delay_point(). -- Paul Kim