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 1wAq2A-000Qgy-2C for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Apr 2026 14:07:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wAq28-005uf0-2S for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Apr 2026 14:07:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wAq28-005uer-1H for pgsql-hackers@lists.postgresql.org; Thu, 09 Apr 2026 14:07:01 +0000 Received: from mail-lf1-x12c.google.com ([2a00:1450:4864:20::12c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wAq27-00000000Aqm-0qpk for pgsql-hackers@lists.postgresql.org; Thu, 09 Apr 2026 14:07:00 +0000 Received: by mail-lf1-x12c.google.com with SMTP id 2adb3069b0e04-5a2b5ea59a1so1010469e87.1 for ; Thu, 09 Apr 2026 07:06:59 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775743616; cv=none; d=google.com; s=arc-20240605; b=QxYBcn9s5qNXXFXDRG8uHviaGD9u/0tmwwh/lIvsGAGoW47hhTfa9jVNGvCArvM/Mu v+gNunqeF49AR1rcmMNNNyb1B6FZFOsXEULrtfFYhC1VeZYVu/ZjGcpeif/mWhqUWgAG yJ75CHYMza61XGdS/6Q0uHTqg8l3GkP2QVpvrn5+Nji0fK+jn4yiXvYzkP6KRpNU2IpJ gApG25PBTOFvDpeJW2gX9dDewBLyGLmBAgjHywoVhwYTlo04+lIIH+LsGKNptsopkf1R 9TVCTkMXv5gx9fmR6ZFf2+ACW+tP3enUNtLscJ5mLAqAnjet4TEKxSkN4OmiX8zcHUky 9zPQ== 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=1i06MAPHf/cLE4U4P5/6SMp+Afp0buJkp5hYOBuVJBo=; fh=Sf0Y8YEa6Qt8puiv422VeWHf7AjkA5qKUESrgEmMM+s=; b=Fat8O4B2E7lkh16lkta2qwcvAvk85inCSbLj5nDx42DC5NpiTS3FyVYTtuwDmieyp+ 3IukiVd5pfznf1Kw8TzDDrHPyEVe2sTdiTL6WmihTGLOnCsQlHU8DSw7gnl3XDLUO9uX ZILjH8nvl3CXfppTqOJSPLqfmPDfdyCZdKWMjIxBPiMeu9ey+5JRX7J6rJnJDhTIXfki TLqPl2lOKBI2/aX4/4bouLeB/i31EQpk7M+d63JaXAZGc1KdI+mgFFvLxTY/bQFhKE2l 6VTzYADQjn7lb3QQG8bwjJu7sY98MjPpVEKL8u7+ApE0UCaX4Bs4Vfn+kqo3jRpOLnoX 4Tiw==; 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=gmail.com; s=20251104; t=1775743616; x=1776348416; 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=1i06MAPHf/cLE4U4P5/6SMp+Afp0buJkp5hYOBuVJBo=; b=jXqI8mFYRFzF83P6tQo6NwMbtHaoTxKh1zhGijmO7CbOQmDPNHpF+m/VgnzpGS/Fou C3gq/ARVkb2EvK0z9sBTCdOnE+vU9vxx7XC3/U9xvAzXuLkRn0fr0q9BPrbdFwY8S4Y3 Vz8XR2hbcubRXJilCjQn8qCdD18t8RRQPGpJEK3SS5UsZ/WH5tz1OYwGiumXnRj5LDzE e2iySBFqF0e+JwlJlZWYcoz5qp2vvtWFkzvlAlcrh3c2moc0tba3fSGh4rlwg5Ap7Wau okNqhEs250uwWOrQK3MN3DuFir4ltDhigyYKLYQKChSPSw7zOBISeN7SThHyh0LIc4/5 NAAg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775743616; x=1776348416; 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=1i06MAPHf/cLE4U4P5/6SMp+Afp0buJkp5hYOBuVJBo=; b=Mq2bJysYMJoElRbxNS4JosG5Jv+g2Sj154bJlnd9DThVef6vVM/BzVx807ohDm7tAm Se7CtwUxyarm79GDJX/ln669WXnwJJTyLrO2Fc2uvtDAt+hdJm6GOhzaQ1Mng3zLy/xx G1oIhwfj4cmrf3vJ2guL/wwMHidzr1px1adihuh9V05z0uimeVx5/7jwxwe5Lj7NAFI/ 9gZ/+Jb8XixutR4PNU9FDfJSuIfuaSVT6ECuXQiQLVJipSVRG+bpDL2EsESTkViiPkp3 bj5L9HuER2lZTves1Je29PTcW/I6y/A3Jb4Ug4XT7YCN9yFHmR8P2oOqc7unJaZHJJk0 bgRw== X-Forwarded-Encrypted: i=1; AJvYcCURJ9SuA7UlIu0uJn7X7Jgz5lRIuzGOIc1whsp8vrwwllhP7eWpDTZeScFWvbtNVEhQ9f6ocDW5IltpMszx@lists.postgresql.org X-Gm-Message-State: AOJu0YxyNWF1xLFucVn6fBu2eM0042WfNzKUDwPI1pQ7UN79JhYdMCpq 2U8RXcRp1x/Y/cy4K+DkY+w9DHeQ+smMRbNE2NRiITdqqa80RTlCLU9ZjFiq/0IV2EOPS6K9n5q uZKg1UxSe1XCGeqZVn1uA3Ml8PvDbV2e3oCGE X-Gm-Gg: AeBDiesQ/ZV3adcC4l8u0gsdd5a5UNBY96bekiWt7pKv/IvyKkw5xIrYp+aumWEITbZ hTf/X40iSe8iuwHdAHp+DvFr83I7Ip7sUKzU4SFOmPmtTTlhetOQAX/jyn7QLMZ+mUnD8YchLkp ODVRHz1UzjnH/8mg067ceeCxpPYsJfDi21B6t+ZR8NOG11LiGfHV2BPF8WpBXP0eVU+P6gcBqm+ nedE8t2Yk8yijrq8vhGCeWz0g49f0nCoSo5d7n40qfF1RrqoKrsLwV8LduX6ljkVIb2LutanLKV sTnZ2kxYPoSIOjURVxoYeNm6FUmkhJqpPbeERYlaD7nhVI0TCcuvM+9h1LXHTarySRg= X-Received: by 2002:a05:6512:1194:b0:5a2:b40b:3f86 with SMTP id 2adb3069b0e04-5a33757c173mr8051379e87.27.1775743616037; Thu, 09 Apr 2026 07:06:56 -0700 (PDT) MIME-Version: 1.0 References: <202604062213.cgo352cdsgsm@alvherre.pgsql> <4n4q3preb3lgyhpzstebhux7b2aojhsw7gik4ivaznyggiezrs@lrznutssxlh2> <9539.1775724194@localhost> <10697.1775726789@localhost> In-Reply-To: <10697.1775726789@localhost> From: Mihail Nikalayeu Date: Thu, 9 Apr 2026 16:06:17 +0200 X-Gm-Features: AQROBzCNjyLPwDTImezfnmbdEEnnkWi4Up-5BAFZhD99COMve-K3pdSHgSELfPo Message-ID: Subject: Re: Adding REPACK [concurrently] To: Antonin Houska Cc: Amit Kapila , Andres Freund , Alvaro Herrera , Srinath Reddy Sadipiralla , Matthias van de Meent , Pg Hackers , Robert Treat 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 Hello! On Thu, Apr 9, 2026 at 11:26=E2=80=AFAM Antonin Houska wro= te: > Sure, it's possible, but IMO the principal question is whether REPACK sho= uld > let VACUUM and DDLs error out, or just let them wait. One more idea: instead of ERROR in CheckTableNotInUse in case of in_repack - just release the lock and retry a little later (by that time, the repack operation will likely have acquired the AEL).