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 1wQ1ns-001ELI-06 for pgsql-admin@arkaria.postgresql.org; Thu, 21 May 2026 11:43:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wQ1no-009xbj-2f for pgsql-admin@arkaria.postgresql.org; Thu, 21 May 2026 11:43:01 +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 1wQ1no-009xba-1U for pgsql-admin@lists.postgresql.org; Thu, 21 May 2026 11:43:01 +0000 Received: from mail-wm1-x32d.google.com ([2a00:1450:4864:20::32d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wQ1nn-00000000ize-0STX for pgsql-admin@lists.postgresql.org; Thu, 21 May 2026 11:43:00 +0000 Received: by mail-wm1-x32d.google.com with SMTP id 5b1f17b1804b1-48e82c23840so48785095e9.3 for ; Thu, 21 May 2026 04:42:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1779363777; x=1779968577; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=a5/g9uMuHh0xgxxVAS3GjrjvQxUN2BDQZztzBA58ORQ=; b=SdlRK3XbUM8oDNfwK5/APECBoPoGGk3OsRQlMy5nuE7pCYt6+W9Ijde6GR8XSCMPtD o40I0METTZG/y63ieCbmvdGcLbCKNFoGBE44F725/x1Lg9sgmrIcCITnL7kj/FLXRURy 3cBF5/QwwdVg5omcCn9ZNpm9iNOHXUPjImuyOT49Yq9azaEGy2UAu+9pUKzxbesJKcUf UwDkRFve8X/TXCkf1KvMFNHUV/rXgSJMvf/VQVOSNfcolv3cHRv4C3RaApFnMaY4DZ1t q/uaEES7OprojGnKVJwbztf1WPtEtsTf5BPYceGB71DfOOryO8CaAiJm3K+ROS8o0BJr zF/g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1779363777; x=1779968577; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=a5/g9uMuHh0xgxxVAS3GjrjvQxUN2BDQZztzBA58ORQ=; b=hhZAT2L3vgyiAYjxbdOORaFWXW6cmGVS9AOBOOA0pZCF8FO/ZMVQfIOCpvZmT0B+yi +Znv+exK3czBLQQlKkf/kvkT3RKOzab9RvXlhhz/9DC2+7goQU6kOb6u8v76GlrVEYIG u9Lh8CdlW5wgoPEYvc1izWwEgF5vL8XnWPxU4LgVlNELJ0CpGLB/rNcztTXdMw97XPxz rxRwpr6tUSDcvvjBYiAA8buIfresd6Z1T0X2vjnlXCnCC3sfOaDByn/Jk3i9fXPMD57z wKxAkLc7tmHXHyTRL+XBBM6Drhgv0izQh2rXwdO2s9RFJIFsvpBtsP4WUrYLswnDAb+G 14MQ== X-Forwarded-Encrypted: i=1; AFNElJ8ZSxwkZmg0Xksd48z16GQrJpVxGcKOiyaAPLSitlclHCJGFxszdkb+tZhmRGIsareGpwzRvkF/pE6qIg==@lists.postgresql.org X-Gm-Message-State: AOJu0Yxuyo5H5h+i4dBG7KVCVXI1b83vqUqRkNAtlYEcDv80N7F1huky 7c6edGmMTwfI7feXv//NWTwKGE5HMRlj13YrtbBFMhUKrU3Ci5ghxmuEwgjLiX7HbR4= X-Gm-Gg: Acq92OEfmElBLIO/8E5weP5x5iE4djaHluDTm3F2iKz4mbvqUMPh/tCDwTm4lPKkvK6 cYJVlb0ZtY71dLSQcb2jZWCeCWGBLRZ00F4Sf7iQFCJPrN1ioNpNODE+NtgPwyl/HoqBnKP6c+o YbnhOnWK8aw0eioKERsLAHrisgaHyWLse7PZdTXnv4gTQZPEj5VBuJI/rKnLndSKyL85ackiAHj mZyMD8HlykAULCv1elw5ZLT0O7GjeOECSzrcwdO4A1jm2XMugvNcyBV8lnVQzssXrmFpnBANTeu MNXGZ4yW06LGL6fxB+LhiONxlqyj0PTFzkmNjofUeOvsOvU5Ys/PM1TTfJHHN4GcU3TRrPQk7Wj Qvzh2K6dU/nAMpp+56+nWoTpMCo4SvF9kwk4XyuZkpeoUXP8P8Oz6d/zEE2Q47SGtEs50C4D9ud pg7xIDbWV6t2N/3sxto6Z5kZn4CVnetoBIX1CpbuglFvqkJ6QnspOILL4YizBDtg== X-Received: by 2002:a05:600c:b95:b0:48a:8b02:ae91 with SMTP id 5b1f17b1804b1-49036067420mr33167635e9.11.1779363777558; Thu, 21 May 2026 04:42:57 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([24.109.50.222]) by smtp.gmail.com with ESMTPSA id d2e1a72fcca58-841549c4b82sm1065612b3a.3.2026.05.21.04.42.56 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 21 May 2026 04:42:56 -0700 (PDT) Message-ID: Subject: Re: Partitioning table - Update on partitioning key From: Laurenz Albe To: Raj , Pgsql-admin Date: Thu, 21 May 2026 04:42:55 -0700 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.58.3 (3.58.3-1.fc43) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2026-05-21 at 16:45 +0530, Raj wrote: > Update happing on partition key. >=20 > And we get error 'Tuple to be locked was already moved to another partiti= on due to concurrent update error.. >=20 > What's the best solution to handle it? Could you give us more context, like the exact statement and a description of the data it is operating on? If I had to guess, I would suspect that your UPDATE statement tries to modi= fy the same row more than once. Yours, Laurenz Albe