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 1trgPo-007N10-RC for pgsql-hackers@arkaria.postgresql.org; Mon, 10 Mar 2025 16:55:44 +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 1trgPn-00FegJ-6z for pgsql-hackers@arkaria.postgresql.org; Mon, 10 Mar 2025 16:55:43 +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.94.2) (envelope-from ) id 1trgPm-00Feg9-TR for pgsql-hackers@lists.postgresql.org; Mon, 10 Mar 2025 16:55:42 +0000 Received: from mail-pj1-x102a.google.com ([2607:f8b0:4864:20::102a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1trgPj-0024Y2-13 for pgsql-hackers@postgresql.org; Mon, 10 Mar 2025 16:55:42 +0000 Received: by mail-pj1-x102a.google.com with SMTP id 98e67ed59e1d1-2fecba90cc3so8759429a91.2 for ; Mon, 10 Mar 2025 09:55:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1741625739; x=1742230539; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=wTchT8Q+eQAaG9JfeS6snLWqvymkVIMFyk2MM6te4WE=; b=kepG6wjcSY3ldatrODYUSO5RHOZgkEoXVbCaftoWhY3MBJ90VisnPrAF0c1eGpsOuY hjEOEobZmX7Nn1VAvEeNkj7e1xZoSbkyqeFQ5Nppu32wOk4AHxIRN587bQD0o2kzcIBs kr78MSt10ZflprDB6kuqDr3mPJ2skpXc/5ScALbqXJ9ZJYQuagUFIkuuQBbRqVqqxMXT blWrBdYGmWoArEeV7Ij2NJd8SdmAjQgYXheWH5/u24U4jB4C6R48AmBMPODgXnRehAaq gIEKYKNaTM+j1IpME6R3tNXeTOQ4GAD5fPfxK1pr7WKO0cGq4nK6iozWRoDHT50l7xkJ M99Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1741625739; x=1742230539; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=wTchT8Q+eQAaG9JfeS6snLWqvymkVIMFyk2MM6te4WE=; b=vYnU7w5zOoe+Bx5DN5f6LVFXCCZfG7D5K6I/Gim/tV44KsvPyBW94exgKpC9o7yOnm LXs1kzHD5Eg5UEm7eRK5zQisFpKEOppg7KyI1IzILdnUO9sxYFwE8T9ihijId2yH1t5v N5gBo65Im2QBsqkNKMu+IlSo/IokAcGJPQZ/5LOB8hDaA1iTjdzMOUVYXKhu1iPjmnD5 kYJkufJRJGvRtld9MciCxeczkAvSp75B6PR5Lz+bsP1agDLUAkpy7waTfwUwZnO9TKm5 SLYlSYoT5OAN+d1FQDacfx0hPsi0D8f57UD1pfcdlDQeCU3yLohotTvb5gQUC+e/YHTm Ph+g== X-Forwarded-Encrypted: i=1; AJvYcCXFl8ne1GY6X4LjMtOd1AuihAMh3xV2AYwe9HF0c6cbxJUG8K4QVw5VPlA+h9vDWs3Td6tvGZLA8OeMp9mO@postgresql.org X-Gm-Message-State: AOJu0YwbYleKRWvboJnRvnyulVNgR+9FAiyY10M5l2V/35Cb+kq4dl6Z Lww8SBiL2rbJbiOFxx5JxiIlOM9grCiH+0LiT3qW2Fc0BCNoPuUOsctzN/Rx2a21L8Y80qz7Vht YEw3m2+KFH1tWmj7tnTATMOWhDBg= X-Gm-Gg: ASbGncvO1rBtWTCUtW7VZxFBGcIeX3o8ekwZzFo+Yp420ismXLC0FsWe0uIdf6P9aN4 nMwWUeOx+0051RZ8daE4vIHQKtVKqLkJtN1go2I+0+FLHN325Jn7P4koALh9UBPyEoaAHrgWvMa rTkat7bSVB4s4Z859rUzVrW3qVnw== X-Google-Smtp-Source: AGHT+IEnbax42F1Kf2loLMCov5Dz5YVNdYjb5PrDAMMpF/3FdxyB9BkW+Ye7ezmtBq/27rOyzgSgz7WFcyOj2GiaLv4= X-Received: by 2002:a17:90a:d605:b0:2ee:8ea0:6b9c with SMTP id 98e67ed59e1d1-2ff7ce63686mr27979354a91.12.1741625738459; Mon, 10 Mar 2025 09:55:38 -0700 (PDT) MIME-Version: 1.0 References: <83d243d6-ad8d-4307-8b51-2ee5844f6230@iki.fi> <190b4c9f-8173-4f0d-9877-a7aebb7c41c9@iki.fi> In-Reply-To: From: Ranier Vilela Date: Mon, 10 Mar 2025 13:55:41 -0300 X-Gm-Features: AQ5f1JqK-UrWfjReSko311PR9Dwm7PoIasIicgQ8HH-SHdl1EFUp-VRNer1Z8Bw Message-ID: Subject: Re: table_tuple_lock's snapshot argument To: Heikki Linnakangas Cc: Alexander Korotkov , "pgsql-hackers@postgresql.org" Content-Type: multipart/alternative; boundary="00000000000079052a062fffd7ce" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000079052a062fffd7ce Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Em seg., 10 de mar. de 2025 =C3=A0s 13:52, Heikki Linnakangas escreveu: > On 10/03/2025 18:20, Ranier Vilela wrote: > > Just for curiosity. > > *RelationFindReplTupleSeq* on the same source, does not suffer > > from the same issue? > > > > PushActiveSnapshot(GetLatestSnapshot()); > > > > res =3D table_tuple_lock(rel, &(outslot->tts_tid), GetLatestSnapshot(), > > :facepalm: yep, it sure does, and FindConflictTuple() too. Thanks, I'll > go fix those too. > Thanks. best regards, Ranier Vilela --00000000000079052a062fffd7ce Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Em seg., 10 de mar. de 2025 =C3=A0s 13:52, He= ikki Linnakangas <hlinnaka@iki.fi= > escreveu:
O= n 10/03/2025 18:20, Ranier Vilela wrote:
> Just for curiosity.
> *RelationFindReplTupleSeq* on the same source, does not suffer
> from the same issue?
>
> PushActiveSnapshot(GetLatestSnapshot());
>
> res =3D table_tuple_lock(rel, &(outslot->tts_tid), GetLatestSna= pshot(),

:facepalm: yep, it sure does, and FindConflictTuple() too. Thanks, I'll=
go fix those too.
Thanks.

bes= t regards,
Ranier Vilela
--00000000000079052a062fffd7ce--