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 1vUUql-00DW7l-27 for pgsql-hackers@arkaria.postgresql.org; Sat, 13 Dec 2025 19:00:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vUUqj-00BRy2-2d for pgsql-hackers@arkaria.postgresql.org; Sat, 13 Dec 2025 19:00:14 +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 1vUUqj-00BRxt-1b for pgsql-hackers@lists.postgresql.org; Sat, 13 Dec 2025 19:00:14 +0000 Received: from mail-lf1-x12f.google.com ([2a00:1450:4864:20::12f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vUUqh-000ZUx-2S for pgsql-hackers@lists.postgresql.org; Sat, 13 Dec 2025 19:00:13 +0000 Received: by mail-lf1-x12f.google.com with SMTP id 2adb3069b0e04-595819064cdso3456599e87.0 for ; Sat, 13 Dec 2025 11:00:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1765652411; x=1766257211; 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=STtFaz+06c1lzV0aoIEuVM2dZdbN+Bw6++/njdptHVM=; b=kte/1tpWfLmlZdDP7BR1uXbIbE+21eKSXkeYFamqZMRSJDX/egaToZMZ3UWlxY4OvA ovBgVcAb5dsZiWI2wjLQRzw3CVaZ4T0JrdAUjwzz62m3SRvWe3HsAkzqCZhYuog36Kld QsCPIf90EVBQEffgrMdsb/7g6kf59PnnIfyuLTa9aOGk2ogh3kw61isSGa8Uj2r9b2Y7 sVeWD4+pcl+eQ977BB3d1gboJ5tcbUK8syBFelCY4qKEaMD9oxXe4JSGj4EJqeR+E4Mr CaVFUM2Wv0U01PPJ7RDda8LoSVWQJh7mvRWA0Zd8/6BIQPDBcrL0NYxeSN6uwdBL6qSN eEiQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1765652411; x=1766257211; 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=STtFaz+06c1lzV0aoIEuVM2dZdbN+Bw6++/njdptHVM=; b=RkTeLqigd9nlFXePiSll4y4AMTAburZf/juo+E+uG/QutCqAxtrlvi1m+bNdoU+S3S efxb5hUbn7xaws7WrB8SlcM4MjBV8RQbtTkmERwf/qHx/m2gKzZ++ZJqHc3vv4wZVytM 9sqRU+oCMEV4qPvMEC73LeQO/N+LKSL84T6g48tRK5MGT5dC1xzac5BZBJbJb9ONsvms boK+aGluz4AtW3YQN01P4w7MEbp3FLyqnRKxrLYVj8KbstMf5gKC3GGNezO9mYq0pY1Q m+xpanCEaAc3WA4xy118BkOgOPiee+3PWIa9BWGYhV0ahcp0S8RZXYZK+9pMBmX0lZYx ToaQ== X-Forwarded-Encrypted: i=1; AJvYcCWy7ZBsTBT49/9D5iCeAEYYJxJXE5TErPadq5RPkW1S8yL6hDLl3W+zoK8GtfkGpQA87DQt/jMEoGx5Q/pB@lists.postgresql.org X-Gm-Message-State: AOJu0Yx7KLmCiQzteL8b4tRy/g3Bvmq3I9aykplDZF/xAwZp4zPZQGai /5D2koooi1PPODMLA0BSxHqmUPMx0ORhPwErMpPRue3BFNO1Nargh39xyrzCLm0AXFlKfRxpanr /Tc1m4V7FoYP7X0G8zDrC15cjyTKr1Ho= X-Gm-Gg: AY/fxX6YHFylDnL8jxAjHP57qhciGUxuKwlSkqF4QlAnmPmW9gciQ8tbcKbaBYy0iQ/ P0Ba8zR/loRJ++KxelxTQSQuUMXvM/trIXv3psp+W1aviirirLUYfPTdumxfKjUhylauWv3Vg0N dHnhQi6EEvEwxUb3/1a5rX1ELWB4cKsHkYREIWJ/AwloCN5dYhTAw+QGfj/LHBXmunQa9SwlmLo V1Gg+kMlYtmLKjjWDy0i3QoaG4EdEZmsbhdcFXpFQ/WD8RyvNFf6ZAX7IHq2i6DDiYVIs0= X-Google-Smtp-Source: AGHT+IFz8pdKuPkNBRP7j5d8LXtojeE1YNS/N5ZVlthPfRVrKtNZxTDR6Cui9MxDGOGGRL9RTsSwQijv0RRQB5GOKfE= X-Received: by 2002:a05:6512:b17:b0:595:7d7c:59a9 with SMTP id 2adb3069b0e04-598fa6582b2mr1955373e87.22.1765652410535; Sat, 13 Dec 2025 11:00:10 -0800 (PST) MIME-Version: 1.0 References: <202510301734.pj4uds3mqxx4@alvherre.pgsql> <116433.1764870207@localhost> <171530.1765306357@localhost> In-Reply-To: From: Mihail Nikalayeu Date: Sat, 13 Dec 2025 19:59:30 +0100 X-Gm-Features: AQt7F2qKZ9tdFvJx4dBb1YI56Cv1SzSrFbsgjmBJizC06tvdDpUpvRVxJ4vJrVs Message-ID: Subject: Re: Adding REPACK [concurrently] To: Antonin Houska Cc: Alvaro Herrera , 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 Once it was sent, I realized MVCC-safe fails with 007_repack_concurrently.pl with TRANSACTION ISOLATION LEVEL REPEATABLE READ uncommented. Don't know why it fails - but happy it fails :) On Sat, Dec 13, 2025 at 7:45=E2=80=AFPM Mihail Nikalayeu wrote: > > Hello, everyone. > > Stress tests for REPACK concurrently in attachment. > So far I can't break anything (except MVCC of course). > > A rebased version of the MVCC-safe "light" version with its own stress > test is attached also. > > Best regards, > Mikhail.