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 1w4xRk-002k4u-39 for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Mar 2026 08:49: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 1w4xRj-005PFz-0N for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Mar 2026 08:49: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 1w4xRi-005PFr-2a for pgsql-hackers@lists.postgresql.org; Tue, 24 Mar 2026 08:49:07 +0000 Received: from mail-wr1-x433.google.com ([2a00:1450:4864:20::433]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w4xRg-00000000qdL-1Wy9 for pgsql-hackers@lists.postgresql.org; Tue, 24 Mar 2026 08:49:06 +0000 Received: by mail-wr1-x433.google.com with SMTP id ffacd0b85a97d-439fe4985efso3232722f8f.3 for ; Tue, 24 Mar 2026 01:49:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1774342139; x=1774946939; darn=lists.postgresql.org; h=message-id:date:content-id:mime-version:comments:references :in-reply-to:subject:cc:to:from:from:to:cc:subject:date:message-id :reply-to; bh=VJ7br4fyiYHd7mMWDoi0WwjPKp6AlfzRY43k8RLtuzg=; b=VCv1XfXJ6nKLii5Tzzre+rjHtv81G2UmDaczx046g7yeZ2qd73gRtn0L3x5zWW5WQe RemQv/jRnoy2PgDE1SMfTI2AwKGzoIbrPIGfcRxAWI2/3nN5iPedkFMjI1FB1/XimhXT LeUOufn8ee9UNYOwOhyijPXOc2324lbtHI0pPevuHNalmr9DYI9wHYOmZUhILoA/xxKY eGHkZeusn6jhU4bUNfWtNY6dkqeeJ3Qf0uVzPggdUWQ64zoq5yDEJ9JBLPnsGx6tSlXr 2dCq8gAkiSZtbg3oVTAbT8uhVHUvT8Ppz7aUjzLPF1sZm2mhmRvfMjYCjuq+tAcrcyIv Naig== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774342139; x=1774946939; h=message-id:date:content-id:mime-version:comments:references :in-reply-to:subject:cc:to:from:x-gm-gg:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=VJ7br4fyiYHd7mMWDoi0WwjPKp6AlfzRY43k8RLtuzg=; b=soPLum9r7e0UxYw5Y8GPyr2GbLgsxIjaHHoN6E+Kujp5DA713n2us70uy12IayGltg PxkNzcmF0oam/HTt9DFjyUN7Zur+7ncwaCmT6IDvU5B2G6VCTBI8XoB4zMi5tpwTlrRu AR2tlgWrFXBnQZ9A8BJcT+oc7/KYi4nSzIJW8QIv0Wsd8quAtJYsIjoN2wyOXTNYLizQ twLkWIHJTXd0odtkdgoW2LMWw6SMji2Gq53eA2FaTc1w828gbxGvvBlXSw1+KgVZIXMU IYye4sDL+jEa038xMQZxeKYDkSdQ2xGfktg0FRAqZ8eaHg6CDwwMyYK4XzvXNocM5AmM Lu9A== X-Forwarded-Encrypted: i=1; AJvYcCVOgNljM3xvWCIVJfHsLWVcgKoWFBKT043KpaznwCYKHMpOR/LamJByk3cjE1JHfVbPN0eBAy/zOtf5bDmw@lists.postgresql.org X-Gm-Message-State: AOJu0YyszO3i6P64U5pXra6ApNjyNoAnsuX9EYk/87TK3v9GlNy3GrL/ AW+ANx22AcW4tRH/lwmhFk3pooYRZ0Ek/C4OhkWM3MtznRpcURosnHn8iBYkcPYdgc8= X-Gm-Gg: ATEYQzwn+OdUSE0vUyKcM7KEAlWPeUVrVR5PSQjFgEUAfJTRiNhA+XGIp480YRSRFZP nDcRtCb9hAZZOi5yKdbfOW2EV2/2OQRTYMDMSE/E4JeR6ZpeHCIsr4pvK+tSaKVa2fqcM6wGmkJ alY51+RGzWb3tYmonHDxEjplrc8abk+7JzDAEHVhPn2lYkFxDkAp3yemaKeZCAHRhup4d2OKgZR A8DZSbqfee5+77zyyiOSF49ggWpSsRYbffTxAjRY8MDV/WCoCu01QGBTbaNtpCbR8hdbZnTIRyu fINyx7PpHMQJOAap1Z6k2ypVFfb2bOQmxeibhPID2DW7USgJAp9RENkJpagBTIyq1FEyiVmNLRC ehFa37r9+PchDiKTa+PWwGJvzd34Df7GzP00m3MlI3LP7AH9jgTBOXJR/7AY+MnzC1VqqIAZhc7 MkKhdA6xiYljF9uEQDed+8ZS+gShqtEOBDZOzJ X-Received: by 2002:a5d:64c6:0:b0:439:c78b:cbef with SMTP id ffacd0b85a97d-43b64263ea1mr22965617f8f.25.1774342138521; Tue, 24 Mar 2026 01:48:58 -0700 (PDT) Received: from localhost (109-81-168-142.rct.o2.cz. [109.81.168.142]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-43b644bd0dcsm35666725f8f.11.2026.03.24.01.48.57 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 24 Mar 2026 01:48:58 -0700 (PDT) From: Antonin Houska To: Jim Jones cc: Srinath Reddy Sadipiralla , alvherre@alvh.no-ip.org, Mihail Nikalayeu , Pg Hackers , Robert Treat Subject: Re: Adding REPACK [concurrently] In-reply-to: <713021dd-bf6c-407a-8c9d-f79ecbd1c2ee@uni-muenster.de> References: <202602241757.6ac3iss2u4vo@alvherre.pgsql> <9116.1772009759@localhost> <100248.1772048475@localhost> <4200.1772781295@localhost> <29157.1774029970@localhost> <46846.1774267234@localhost> <713021dd-bf6c-407a-8c9d-f79ecbd1c2ee@uni-muenster.de> Comments: In-reply-to Jim Jones message dated "Mon, 23 Mar 2026 17:07:24 +0100." X-Mailer: MH-E 8.6+git; nmh 1.8; GNU Emacs 28.3 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <13636.1774342137.1@localhost> Date: Tue, 24 Mar 2026 09:48:57 +0100 Message-ID: <13637.1774342137@localhost> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Jim Jones wrote: > while reviewing another patch I noticed that REPACK is trying to access > temp tables from other sessions. Thanks for the report. I agree that there's no reason for REPACK to get blocked on a lock of a table that it will not process anyway. However, as both VACUUM FULL and CLUSTER in PG 18 appear to have the same problem, I'm not sure your patch needs to be incorporated in the new feature. Adding a bug fix entry to the CF seems the appropriate action to me. -- Antonin Houska Web: https://www.cybertec-postgresql.com