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 1wACLJ-0029rS-0f for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Apr 2026 19:44:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wACLH-0028oi-1r for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Apr 2026 19:44:07 +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 1wACLH-0028oZ-0T for pgsql-hackers@lists.postgresql.org; Tue, 07 Apr 2026 19:44:07 +0000 Received: from mail-ua1-x935.google.com ([2607:f8b0:4864:20::935]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wACLE-00000001Af2-1pKW for pgsql-hackers@lists.postgresql.org; Tue, 07 Apr 2026 19:44:06 +0000 Received: by mail-ua1-x935.google.com with SMTP id a1e0cc1a2514c-94de68feaf4so3152157241.0 for ; Tue, 07 Apr 2026 12:44:04 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775591043; cv=none; d=google.com; s=arc-20240605; b=MSyXiieWxLR2Pk64rz/O4kES5soq4ChIVhsVfdTyxYv3iVvruXGawZ51VxXpopMCgp bXPl8tO2e3cSWXmmFgolNgz099fyKuG32Y3z3C7H79x3/TSulGvuPjqstJqwBInXyKXV 5cUnDrW/+q5flNuTyLDrCoTWbNutQH3W7BklCj5oanQceiFvbDzHg/jtpxrd/laaSzqa CADCq/ZwxGJwE/a+t4/cKr2GLDd2fGQLzqiHZEb91NkFBlhxkH4IMqseJXtowhRU5jXO RtZI/hUcFlgVGGprpya8lzG/3QpDxCvtne2DNgqE7DhTPwy9rkmDJjBWq4fi1HHYWIxC Zbbw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=XDPaIZTKHJcdiU51FjlNDT1E64KRij4OGGQApj945eY=; fh=38ZokJe4PC0XcQTR1849OwHtOT9bTcvVlvfBrs0F780=; b=eBn0/v0/eRjDlYrPY+kxt4Fsgns7k/RbgZ0GXB2FXyLY6x53AgtS3pjx2DDnAVVL4M MHQLj2Qav4XmNiKQdxJoS9sdFc1mscAZjJdCZuYj+BvG2zJdfzM63D2rQBa0mZOwLGsu zcpcUaqqwThSI+y72qqfCWYgI2NQT712ByDK0FUOODitPdDZNYiF0+UhiLqPMC8TgY5W LhR/9aWLnYOagKEd8+V9QHVWFmWLTXZrtgaboHCnReGGJLdqk1q6cWp89pnxfMx1TqM7 OGJy2KEX0iWyFtJ3Bz4a9KPyXv+shU1XQ18wTjjYVL0TvCk8hRxgriwCWbo16Hu3QzjV 5qBg==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=xzilla-net.20251104.gappssmtp.com; s=20251104; t=1775591043; x=1776195843; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=XDPaIZTKHJcdiU51FjlNDT1E64KRij4OGGQApj945eY=; b=F14itrRbDOdCQcBFWgmcyBoO3JH/r/1uhSc8zRzcFnjmznYa4R3tZs6ZSX8/y0mxpb FUu0ZHjD3oZyMGfoo6dvGyBlYohGb/su/z/32kJNY3C+cvYDxKyKM9EinaDSC9b6XkDL rZSoKyio26jWcPdjBRsuyvBeHdRZxRhEBooq8EHBiqyEtQ82XyCwP5dq3yNkZH640MSy xXAEExoIjJxvaqGpT+WevsEc66+MdpmUIRq684iekuqiK81wLScG6hTEF/13MrDfdSHt eUewO2+/Adw/hm3Qz2plz22GqKDnBph4pIOaRRKK8hQSz7/tp5axgndorhuWNLn9PE/4 Db8w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775591043; x=1776195843; h=content-transfer-encoding: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=XDPaIZTKHJcdiU51FjlNDT1E64KRij4OGGQApj945eY=; b=VOer0MTVJ2vM0uAFt/aQXr2QapGXmskWfPZRbzRnUj6SeFSU8WELVNEWEMY3lFM8Q0 AL4aVDsE6+OLbfheauChHH+ycp4xe0h1tx5MHmIgsF0+fmti2jspX3twRs7tkpqmutlz 5x7/FXhBzeOmpDKGIM1KsxSnTwFg+ikjO037BUwbTWcGqmv3bD0Iz2lBBsQ2RLhP7+tv G3oZk/LNGlbmmbJ16kMili2JUdtKutiJ/2yjVoCNVHg+7X9107WGqSTyYTKE0hvgFwdv BaPRUzMMcJwe3wCWCPG86Mz4ETKQmZjQgKjx5AHWS+41YpFzZwLjLhzehZaaAm8gAW9j dAng== X-Forwarded-Encrypted: i=1; AJvYcCWOmW/R+V3Niy4n1f1J0HshfJiXmr1Z+kL7FH7Yvwpr/NBlPicnmDAW5b5MTTq9SotXXxkvTvjLxNcxEmjk@lists.postgresql.org X-Gm-Message-State: AOJu0YwHriP04A5eGQ12GJfAoEWhyvcjIdo+ZSj65E9BhZso+lfXlsn2 +LhsD2rWBgyxsATKHVmnJ0ffoJEc4IG1c/jZdJy8Njpmm6nrvQbEyVlJBjTWMcJYWFiErRSbTXF kKcZNgw8IXaFCs68klzt4DugllYjHVgfZ94urQla8Kw== X-Gm-Gg: AeBDiesY8xXrwa65gYMbe7ePpusE0hzybIWrWuoR9knnPN6wYjUoOeV1xhmywI5hxJa 8QsoQCdO2ePIF05ZS/hS4MA94oFJI/Yrj1GQLvQAhLOnlzgTZjRfs+npv9HNkpzmGrTF5utB11q JJnjVSEf3Th4LKQF2zKGdVjC1uA55KMU1bVPmhnjuGAmioQEP1AjMhNFNFIbitFNtoBVKY/dLhI swLUhrcMhM2dIUw0frgr8OsP7ZLicX3pClU3Kb9YP2YHzuFoOlNQ8zmK88hA/a/yznM+kSzLcZy vlTQVRA= X-Received: by 2002:a05:6102:148f:b0:5ff:e25c:928c with SMTP id ada2fe7eead31-605a50d5344mr7145183137.24.1775591043112; Tue, 07 Apr 2026 12:44:03 -0700 (PDT) MIME-Version: 1.0 References: <202604062213.cgo352cdsgsm@alvherre.pgsql> In-Reply-To: <202604062213.cgo352cdsgsm@alvherre.pgsql> From: Robert Treat Date: Tue, 7 Apr 2026 15:43:50 -0400 X-Gm-Features: AQROBzBBc_TbqNzheMq1th6ZM43wCsNl9b70cHlpofYDTORp83moR15_ezvTNlo Message-ID: Subject: Re: Adding REPACK [concurrently] To: Alvaro Herrera Cc: Mihail Nikalayeu , Antonin Houska , Srinath Reddy Sadipiralla , Amit Kapila , Matthias van de Meent , Pg Hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Apr 6, 2026 at 6:22=E2=80=AFPM Alvaro Herrera wrote: > On 2026-Apr-06, Mihail Nikalayeu wrote: > > Anyway, here's the three missing parts. I have not yet edited the > deadlock-checker one to protect autovacuum from processing tables under > repack. > I have this lingering bit of paranoia that users could end up in a situation with a large / long running repack that goes past failsafe age which prevents the simpler fix of failsafe autovacuum from running. While the repack finishing would resolve this issue, we can't know ahead of time that the repack would finish in time, and statistically speaking, failsafe autovacuum should generally run much quicker than any repack could. I'm not sure if that means we should let failsafe vacuum cancel repacks (that seems a bit extreme), but maybe we want to help $operator to think about this decision, except if we don't allow autovacuum to wait and we don't allow it to respawn, I wonder if the end user will ever realize they are in this position. Granted, there doesn't seem like a clean fix for this... Robert Treat https://xzilla.net