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.94.2) (envelope-from ) id 1uswq0-00DTRy-9s for pgsql-hackers@arkaria.postgresql.org; Mon, 01 Sep 2025 05:12:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uswpz-004VYO-PM for pgsql-hackers@arkaria.postgresql.org; Mon, 01 Sep 2025 05:12:16 +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.94.2) (envelope-from ) id 1uswpz-004VYF-Ef for pgsql-hackers@lists.postgresql.org; Mon, 01 Sep 2025 05:12:16 +0000 Received: from mail-ej1-x629.google.com ([2a00:1450:4864:20::629]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uswpx-002mn8-20 for pgsql-hackers@lists.postgresql.org; Mon, 01 Sep 2025 05:12:15 +0000 Received: by mail-ej1-x629.google.com with SMTP id a640c23a62f3a-afcb7ae31caso754277866b.3 for ; Sun, 31 Aug 2025 22:12:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1756703533; x=1757308333; 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=hPzjZaoX37hK9SdZYWxZQci+h0q+AfIO4cNlsyt18NE=; b=QNGNKYtvrLGOy2yADS7UWZ+VriAXd+xmCc60+lQPr5GA8wwI2KYVp5EMofAORC/74r TdGRAta8zZVZJi+fYDWlQM/LrDSUz7BB41qQHmBDJu69Lrf2bFwC12GH6Jqgmh3Pseuh mNky5DFByVQVeQyu7GourbXuoeWFb/ro1QeBeH4kWqhF8gWEhNIihbw1RQO1Xxtz9BNp W9KH/e5al9WSYcMLAWe+A4drePlQxRpgOiCH3WZK/oijel4WKJGN35Ezm0U8JlDXRuJ0 FD18Dk4lfs77Cl4bcebMaaAwhohnK0nFiGiAFcx1q71VIYYPw6CF6Tl/DUdXRAMJr7at BSVg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1756703533; x=1757308333; h=message-id:date:content-id:mime-version:comments:references :in-reply-to:subject:cc:to:from:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=hPzjZaoX37hK9SdZYWxZQci+h0q+AfIO4cNlsyt18NE=; b=RL+rcuclbV4SChQBjvwZWmvEuMISrFXuSnC3NpkibN3USIN6dhQ6e5s1dQa00ho74f +FpgY8KA3ygpNJPWe3+iU9q8dHeUshEQU+bKZQ0bB5uFoLE6sAX417aiNz2b2qmE5zoo bPZ95NUlnAmJ6Cplvo4vR4Dj3iQf9QQzGNGWdzirmcj4aftgg/xXyO1JSzn1+8pCsqik WQpxZEUxlu7bDnNCLFiTFrLmMf5f0D1O2Fz75eEE17/BbLzzrLypCC3Y6JWWqEF6y+Iy /9UQdfhcsDnl2nSlIi69BYDzLoTR8TLaonbCcWZKox7AcxThXhl5AxrQ2XAC4Bnj0bKD 9AMA== X-Forwarded-Encrypted: i=1; AJvYcCVBP/Jwchrv/JIQOJaxX4h40pnr9Te7aqD/JwuXC1+eLjl4Sy3xg0jMPsBkQjJ2fVnkJMJx7enZN2p8PTwK@lists.postgresql.org X-Gm-Message-State: AOJu0YxG7XiqH3+ajcFrGGeDuq4Garbhmeu65zim+vprP+5H6mL2uPZu lPKWo6j+KjVg7NwnqGTYX9iZeM4loOlTyZo0LNx9dQ2bK0sBn5ClA6+JTTHBkg6xvjPpgpLYrh+ nC2La X-Gm-Gg: ASbGncvvzX3gQtrlk40mylYcMIQTkWllOxIs4DZRRLO9hUME3gnC4FNEym7hUWxuB7r 3gfShCC/vvRXJku9q2CtOHLmHygoNkzxC6V+0QmDPOQJKqf1AfWJCnlEDaJOdWJxfS9H6qstBml 3CvEKxffQ1vzIf5c+IpiONrMEPLYh7I/9o5ISOboOuXyG4m4FxubJh6hzylpkyS5d4Iwv51mVYN eScMhJze40ZbjVmqcJEy+RSXN9NUO/2s7/olGXINfr+62nWZwwF625ZSmueQh/dwEXsHhKD0kj9 2XOVcxnew54OLNlxA5f9Z9POAlZPqlRVF6UBAAkShgXNWZNVKbGmIbDPzahpa3OaH61VgR0/Jnx tfLws1uqDZ3uMvg1+vxqhmcIY+fNTOGRVPFFA X-Google-Smtp-Source: AGHT+IEzp2MyLRn0rUqwMVzJlW5u9cNi/JevaNhK+1+blwg2gSpERHUo/Cs5JEbmGCNQ9QZWw/U0qQ== X-Received: by 2002:a17:907:7f90:b0:afe:c224:6cd0 with SMTP id a640c23a62f3a-b01d8a2f930mr538972166b.7.1756703532585; Sun, 31 Aug 2025 22:12:12 -0700 (PDT) Received: from localhost (109-81-168-144.rct.o2.cz. [109.81.168.144]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-aff0a591819sm678382166b.41.2025.08.31.22.12.12 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 31 Aug 2025 22:12:12 -0700 (PDT) From: Antonin Houska To: Mihail Nikalayeu cc: Alvaro Herrera , Pg Hackers , Robert Treat , Fujii Masao Subject: Re: Adding REPACK [concurrently] In-reply-to: References: <202508301750.cbohxyy2pcce@alvherre.pgsql> <202508311209.gnvpor56qkdc@alvherre.pgsql> Comments: In-reply-to Mihail Nikalayeu message dated "Sun, 31 Aug 2025 17:29:00 +0200." 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: <4606.1756703531.1@localhost> Date: Mon, 01 Sep 2025 07:12:11 +0200 Message-ID: <4607.1756703531@localhost> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Mihail Nikalayeu wrote: > Hello! > > I started an attempt to make a "lightweight" MVCC-safe prototype and > stuck into the "it is not working" issue. > After some debugging I realized Antonin's variant (catalog-mode based) > seems to be broken also... > > And after a few more hours I realized non-MVCC is broken as well :) > > This is a patch with a test to reproduce the issue related to repack + > concurrent modifications. > Seems like some updates may be lost. > > I hope the patch logic is clear - but feel free to ask if not. Are you sure the test is complete? I see no occurrence of the REPACK command in it. -- Antonin Houska Web: https://www.cybertec-postgresql.com