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 1vOcNf-00Feyw-1a for pgsql-docs@arkaria.postgresql.org; Thu, 27 Nov 2025 13:49:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vOcNd-006Uao-10 for pgsql-docs@arkaria.postgresql.org; Thu, 27 Nov 2025 13:49:53 +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 1vOcNc-006Uad-3B for pgsql-docs@lists.postgresql.org; Thu, 27 Nov 2025 13:49:53 +0000 Received: from mail-wm1-x332.google.com ([2a00:1450:4864:20::332]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vOcNa-001kp7-2N for pgsql-docs@lists.postgresql.org; Thu, 27 Nov 2025 13:49:52 +0000 Received: by mail-wm1-x332.google.com with SMTP id 5b1f17b1804b1-47798ded6fcso4727855e9.1 for ; Thu, 27 Nov 2025 05:49:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1764251390; x=1764856190; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=sqOWQGmOiSkQOpVgFNnazWeEW+kC6suFUnltIOPbopc=; b=R9+177rYnb/JhWifv0ylcxv1QWzRU9qi4MM91Jp6w9i33vHhPT+z6a0PJA7V0W/U6H 3+0Sy9ZMc8mGO6veKWnZTsMNQx0lu8OmvLshMERIPfvFF0+T8vhdXX/fLDc1fuXpUJeu bhSCbwRJvQ/u2fM7hjVgKmnpZMJdObm8bBDKn6Ug2EAhMcHuToOYsHstM7va7D5kToDP YZnTjL0vRLbrNlrbZPQjntj2PsuOR25I4jvUKkB/uLh97oSGubRlp2//ODPEgi1OD+3+ oq/g1Sf+WGEMz6EoF0La/aECryy7P5pIZD+OZRc05JapcyE1HxGr3Gd5qJczTI2BCi2g xKwg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1764251390; x=1764856190; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=sqOWQGmOiSkQOpVgFNnazWeEW+kC6suFUnltIOPbopc=; b=FvMBuaIvH/1cEYk+FSPxeYwP03P2ZLh5X3YtX/gNxsAuQ760Sj/fcyAI/clY+6Ue+J ukPh2D1R74q1+1NZj7854sYA/xEoZypxjNoVIUDEiKAleHtUYufY66BamTEa2e3gDdAl tSKzNUwEdOwRKZB2EpppiJAC8Dmhmu8A5RJoEaBHGrRlFgHgvKIBGijSdH0VVJPuryo9 ZzHnVM6v0TnXn1IWiLtH6T6croq1k6RB5VMxhi96QNLUr1W94TTb4TnASYoLqioLuXXH JdY7oa8yDmMQrVmEJcKpPG0FtJPhJuzc0n8debAtqN1+Ov8KNI7TQN83ienVVcSxUrMd VSiA== X-Gm-Message-State: AOJu0Yyh0asd/nNbSweEv/uwkO1fevrMTQAeJfNQKmL2vueXe8I4Ffau Z4rvbxMKSdLzrRNSR3EtdUlSfzLD01pOOfI3ZOB2hdBlHjEHqPuvHm/cZM4lEHdcAYY= X-Gm-Gg: ASbGncu/QUmCM32hv1ggAgafyjI6WQ+ONJtbHwWCNGEV2lfWFDb1ki8U654AzoKzukk QWNa46w6v/T2khF0NL9RnB40R3l9QFc5J1WfaZcFbjMmNprVXsS0Mdia87UppEl80bz9tY9mgwY np3jr9JUmhQOVW5IgLca4iqfIue3qDNC4h4N53G/VTEuQ9kDP2eTPyKRo0JX8fAodhqRFDNoStg 1yeTm40rH51R0jmvQiylypS4bZLtDHYQjT4G2hnX4YYzCPrXBy99UbEeMmzAbIRLhfKI3NhbtKA vtt2OQhb1mNXYz8nfnGtxRwsQU0HT+u9hROgsJ3yz56Ts7zasfkaWvz7K9vLo0kRtULAdyVqxh6 RAoIneofgFKDnVhuV8WakdEb4aRIDQi6uPzzEoq7opzM4ElSOeXdncEkJmpmymX2wCwsug87aLC Gl3DjK5LtIydWuUc92kMXlCLksX8p75Bpp8Mc7miM= X-Google-Smtp-Source: AGHT+IFnd3crtN5ccMBcgSdalbvJsnepKQxaVcDgVYJc65tD7zxqzT2BOrizO2RR228mwylw7iS0oA== X-Received: by 2002:a05:600c:1382:b0:477:a977:b8a7 with SMTP id 5b1f17b1804b1-477c1117956mr215221385e9.19.1764251389440; Thu, 27 Nov 2025 05:49:49 -0800 (PST) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:70:209:bf85:c4e1:b839:780d]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-479111438b9sm39136105e9.2.2025.11.27.05.49.48 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 27 Nov 2025 05:49:49 -0800 (PST) Message-ID: Subject: Re: (docs): add missing info about ShareLocks From: Laurenz Albe To: Alpha Shuro Cc: pgsql-docs@lists.postgresql.org Date: Thu, 27 Nov 2025 14:49:48 +0100 In-Reply-To: <8E0BD202-AB51-4FE7-972A-D83838A29D8C@gmail.com> References: <4274DCF3-177F-43D8-8547-90B8540B6619@gmail.com> <58e8295701c9e15c251ed608c5ed297688c785a2.camel@cybertec.at> <8E0BD202-AB51-4FE7-972A-D83838A29D8C@gmail.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.56.2 (3.56.2-2.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2025-11-27 at 12:33 +0100, Alpha Shuro wrote: > Ah thanks for pointing this out, I've moved it to the xact-locking page i= nstead I think that is too specific. You can see a session waiting for a SHARE lock on a transaction whenever it is waiting for a row lock, since row locks are not permanently stored in the shared memory lock table. Rather than adding a paragraph about the specific incident that happened to you, you should describe the general mechanism. Some reading material: https://www.cybertec-postgresql.com/en/row-locks-in-postgresql/ Yours, Laurenz Albe