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 1w3D46-0010dh-0S for pgsql-hackers@arkaria.postgresql.org; Thu, 19 Mar 2026 13:05:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w3Cvo-0003Yl-0X for pgsql-hackers@arkaria.postgresql.org; Thu, 19 Mar 2026 12:56:55 +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 1w3Cvn-0003Yd-26 for pgsql-hackers@lists.postgresql.org; Thu, 19 Mar 2026 12:56:55 +0000 Received: from mail-wm1-x335.google.com ([2a00:1450:4864:20::335]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w3Cvj-00000000YjA-3dyL for pgsql-hackers@lists.postgresql.org; Thu, 19 Mar 2026 12:56:54 +0000 Received: by mail-wm1-x335.google.com with SMTP id 5b1f17b1804b1-4853c1ca73aso7900885e9.2 for ; Thu, 19 Mar 2026 05:56:53 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773925011; cv=none; d=google.com; s=arc-20240605; b=G/KxbJ1LUmZJ1r3HyaJVUY1V1qHVlqtLUYEAhoZc6pM19nGIejXNCRcuVRDvbQUBAd vcw4xagco2+USQktYFYpVIEiWyyVGN4Hy1khs5FuvwIOGmVcGL+SL97epaL/yv1z5j09 t1HNGsl4Ik1v6CWrgM23MVXrmTayO8IpEJNbiDkA/2hOhPi5RpMZ/E2baISnrCZESDI2 STgYbVup7vuEAPL+AypYXr0rudsEAmXlyxbjTEslFUphJRzKGiBmcmLoMm4Xw9MGuq26 TgarSy5Yh9hXIf8Rxsu6n2h7zsNp0mDkOhQ0UQRiodZxaLVouNbVtGZ0ZQ6Ggv8f2r5/ E3lA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=yqFHB0NpY8mHCVjnZKN6/lA8CMSdU8YFIOsrSqmli/4=; fh=Z1Vx7YHkChpGodUnX3TJ8qbkXFVVHgPLL0sDwj4Jrgg=; b=Pjyw4jVSHQMszB1EP829T7Ihv1vw/GfZsTAQ0Om5AsDgHmpFD+ogoqtTMvju14pbB5 TTvCxgj8mldhwebOmeu7HLq8OkYc6n8Sc2+xVTUrXyejoSelC9W9H9h+7LfPYMQNdN+J I8NA0KdC+aT7MKfygg8JZBuVNTWxHT+FEYQ+McYF1NqDJtd7vsOO/mu7hMVEwKbrzgrB Qb6ZP2ORjr0B6DiHzhlWont7Ius683tcuw3oVFSDMQhpLOaSlK+9Yw6yKQnHbmYhROEc 9pK1ap43guMjWGMrygKrbv7QRntC/SAWJrI9CF4Ky5sR9UmaJCmVxbrYO0I/d6pfX2hz RNnw==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1773925011; x=1774529811; darn=lists.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=yqFHB0NpY8mHCVjnZKN6/lA8CMSdU8YFIOsrSqmli/4=; b=H5DYlnnuqPCQmKnPofBqmiPWC3uMXsTfIfq/mLv5BCAc/FMKAEqOGisHH64BAB7tyM MoucoEd5RMeDNb4queBs/DwgZh2QMOaL3EHjXCFhNCmnccEci0HRywB9INHG2xGH3imC 7VBbKM3gYPTO3j+/FuB0rD2nYxc7tyFFoPBUus7bAdtqHMattOMuDIIG/Nao+vFepcMj tsFuirPpw/mnm3QxABTpo38rKNohHPxaJihCmAZFK1BVMpyC6IFUqutu15lVeXVB/t3P +rVHzTICgd+erkg93q+SrF8fHXCi1TdnK0E3dP7Zz00CoWxL43M04wBJBKleYnIB0Tfg 5F7Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773925011; x=1774529811; h=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=yqFHB0NpY8mHCVjnZKN6/lA8CMSdU8YFIOsrSqmli/4=; b=kCmhZChXiHZaH41PuaXzsLcNBNWYpfGRkd/AOwalQNeYjnHglCtzDw9hUXC6kIMz/s ZVA2KByQzIi/CCfa3A8mDhILIejKxi+6yqYQRBOW0LuTLajwnY3SCifbiCfPrevxCREV VGzlFVVxKqHNTG60rpXYYVb4598aSRgQZbYRI0RmKodtWeAHXznoPHmE0DVP7l6Sck+b iIPiQa24anvJotK/n3F8TMxrR3vxwClaC7RQWbMUZikT4S9EylNQ8pbMl8/CjDawVceZ b7KNr4vmv3fxtTE2LjTwUbo0jV1mbWOce14+KUyqRG0ThN5K0aizf73ZXvf4NwHwVLwH ofew== X-Forwarded-Encrypted: i=1; AJvYcCVfruTjvLaa4F7UK+x/KcRhk0CddXdI+YsJNQX//I2rE/8S5mpjsAOC2j0fXeSY0lT08a2GXyJ9C6oW7ItN@lists.postgresql.org X-Gm-Message-State: AOJu0YxqnlI6iPaIzcrDzBGWgE5hCnBJD5/ZJjH2rFE89Ru9l5b/fAEX iGH3tDnSgfn7TIRc42C0xPm0h+ctOjCu2kGW/iien+prvHPJnjBV0es8Nwo5OB8YOZ9/shEh8+6 gHM2LQB02jcoTDiAPVAMDAMNnYxQJSRk= X-Gm-Gg: ATEYQzw68pQqTXCr8mkMXqlCnt9E6sZkF4MuK8xmfkIp6uUa8f1RSzsEpl1Ywxq/f84 Cb5x8ydELwrmnRwkFOxiLd9soFGewGDqSEQumjWHJkQM6uOcWaxWnV/2JtjCh8IlnCwWmO/WYjP /OKgYZBKk+se1wEZt1o2blyoOl7cTw+Y1alNsIjrQ6cgKZZB+O/qeomZx8SkvMC1XlMHFbEhoXg xBnzWcWCICqzJ8+o1vFzQrZ7toMnIbnx9oW7v/YCV6g6joWvQx5MmTEy5h4zK2TF1UXwQk0dc9M ty+EkDNOwCNe2OgPoZyHhGyNMfekQnVEw/iqy87Zw6hlK0xU9Vh0q8xGaLvH+KpEtKrEL0HL3g= = X-Received: by 2002:a05:600c:c4a8:b0:483:3380:ca11 with SMTP id 5b1f17b1804b1-486f4585014mr123889145e9.33.1773925010385; Thu, 19 Mar 2026 05:56:50 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: David Rowley Date: Fri, 20 Mar 2026 01:56:38 +1300 X-Gm-Features: AaiRm538CKFZrQPqikgtS3rivT4xqE3ElKhEkzHcwbyWANG9ZcLjZQUGzcJaL1o Message-ID: Subject: Re: More speedups for tuple deformation To: Tender Wang Cc: Andres Freund , John Naylor , PostgreSQL Developers Content-Type: multipart/alternative; boundary="0000000000001a2d91064d601a4e" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000001a2d91064d601a4e Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Fri, 20 Mar 2026, 01:39 Tender Wang, wrote: > Hi David, > > David Rowley =E4=BA=8E2026=E5=B9=B43=E6=9C=8817=E6= =97=A5=E5=91=A8=E4=BA=8C 05:15=E5=86=99=E9=81=93=EF=BC=9A > > > > On Mon, 16 Mar 2026 at 22:17, David Rowley wrote= : > > > > > > On Mon, 16 Mar 2026 at 20:01, Tender Wang wrote: > postgres=3D# update public.region set > r_comment =3D public.region.r_comment > returning > 5 as c0, > pg_catalog.bittypmodout( > cast(public.region.r_regionkey as int4)) as c1; > server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > The connection to the server was lost. Attempting reset: Succeeded. > > (gdb) bt > 1197 pg_assume(attlen > 0 || attlen =3D=3D -1); > (gdb) p attlen > $1 =3D -2 > Thanks for the report. I'll look in detail in the morning when I'm at my computer again. I guess i'll need to add an extra parameter (that will be constant folded away during the inlining) to the deformed function to specify if cstrings can exist in the tuple, which seemingly needs to be true when deforming minimal tuples. I'd rather not lose that optimisation with heap tuples. David --0000000000001a2d91064d601a4e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Fri, 20 Mar 2026, 01:39 Tender Wang, = <tndrwang@gmail.com> wrote:=
Hi David,

David Rowley <dgrowleyml@gmail.com> =E4=BA=8E2026=E5=B9=B43=E6= =9C=8817=E6=97=A5=E5=91=A8=E4=BA=8C 05:15=E5=86=99=E9=81=93=EF=BC=9A
>
> On Mon, 16 Mar 2026 at 22:17, David Rowley <dgrowleyml@gmail.com<= /a>> wrote:
> >
> > On Mon, 16 Mar 2026 at 20:01, Tender Wang <tndrwang@gmail.com<= /a>> wrote:
postgres=3D# update public.region set
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 r_comment =3D public.region.r_comment =C2=A0 =C2=A0 =C2=A0 =C2=A0 returning
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 5 as c0,
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 pg_catalog.bittypmodout(
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 cast(public.region.r_regionkey as= int4)) as c1;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.

(gdb) bt



--0000000000001a2d91064d601a4e--