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 1vn8uF-002rXQ-2v for pgsql-hackers@arkaria.postgresql.org; Tue, 03 Feb 2026 05:24: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 1vn8uE-003DNf-1g for pgsql-hackers@arkaria.postgresql.org; Tue, 03 Feb 2026 05:24:54 +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 1vn8uE-003DNW-0j for pgsql-hackers@lists.postgresql.org; Tue, 03 Feb 2026 05:24:54 +0000 Received: from mail-qt1-x843.google.com ([2607:f8b0:4864:20::843]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vn8uC-00000000mfr-01hf for pgsql-hackers@lists.postgresql.org; Tue, 03 Feb 2026 05:24:53 +0000 Received: by mail-qt1-x843.google.com with SMTP id d75a77b69052e-502a26e8711so31024391cf.1 for ; Mon, 02 Feb 2026 21:24:51 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1770096290; cv=none; d=google.com; s=arc-20240605; b=TJVdFWjxCF1FSmW5TuEKKmx4Oy1FKRnsuuzuqagN8pNRBF3zeMKV9s4UC7P5JsQSuT HUV0tpHbm4x4LlRna4yOwEUE1aKrd6f4JeCbXqyqsYT24R1bGZVsDDzQ1LU22NXczI7j FIg3JXeFMg57Bw0I36ECtPweh83l9DVos9a64xXUnP9c5ducBFII14zRzHLZjWRcAP15 nKT656fyW7wiz0fYODNSF+KyCmDQVu8C1jBwF0EP2yYwlrsCcC20O6Pc4MFCRj83jbyv iReeA5J2Lw2onwt+y1y0cgyV4pTgvloRIMNdID3m6XyJX0VdoeFwTjDKw/rSNGerzX7Q Ks1g== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=eBs/4BSGxDHgOt4dCQbLdZIKvrk5QC640/3UeJJxuMY=; fh=fTDOrbRbAA5b8VwXMP2W/6rk0XD2Cj9GPucc0tLV6e0=; b=elzbKGwDf9PF0Gbw6akrmHRhACwbHg88i1U3bcvXy20sx4AWGh98diIBec4n3wt57S 7M9tw/IaG9Jm22ZDeLEuoq79sJucoCx6T72QSbfW0O61E2NJIfRNnpaS8meRRLyXxtps mAxHOZbKDU9Aeeq5/FH+38jig0ER7IZB1M3aF0cfsL4lwGb5Dt3nPszf4DIFl/ruG1MM 1A4daA/XoaUVXhhkmalP+Fl+cA7XUkrRYjzFYDGsCdMsUAFZLy/gj0aAu6g1owLLsjZl qdH0fuvNjZgZLre7yOWa0MNWBb8V+wYrWiQxXF9+NYjLOBePJ2BiG7iNbmOXuHUIQAfJ sMqA==; 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=1770096290; x=1770701090; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=eBs/4BSGxDHgOt4dCQbLdZIKvrk5QC640/3UeJJxuMY=; b=Mon1mL03Ycg3Ynj2tgnAxHAWTcl9ev3EFBTZcVO4xioykE4imlyiCEk6gFIZiww5Bj zHdAG0MIrkLmkaIq4KmM6gYcVHdCuyKtBqb/Mpo0kDi1pQLREwkWKNKezU0IoEWdITJ/ lYxWaQK1gZ4wk4m4sdad1mx9sVAsbH7D2JaaZqybJ36k3XtxS1RNDOebIq8kwW+gmKqB n5Y2E7z95RkGF71ibs2HUZ9Ww6jlFaqyZnhuwGiOx3ZCMoRbOCrrHqNhXfMnB0RIS5lH 36QejIEf/SsJZ4gH5ogDq+B2xpDyjwMNEgSq9vELGozbENysO64Sq7faRN5y5mZomXT4 KpiA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1770096290; x=1770701090; h=content-transfer-encoding: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=eBs/4BSGxDHgOt4dCQbLdZIKvrk5QC640/3UeJJxuMY=; b=PJuo+ccc8RL3oo+S3Tx4XqieWIzw78jSvMO6WTZrJzXt/OhPCwbb3PvHZTCcyhxVW5 3nd+0+SdalfgTVNPVMcqxdouj07QJXctXRdMJUzXow+Tvk7XCc9hMPZzcMjIhEnFkwEG WORmHNF4VkhZ/d1uqsusmdpZ0V+HfAdOZ4Fk2a7q/XCdyAd5n/fVM+yai2B+b0OFsuz7 QR9YW+1VZb4NL08TCYgqKnWbXmlQB4fvtFI91LpMt0Z9YMbDyNwYHymbjLrBdVuXB3Mx p5yZ0A+l5pIqz90CU8gaQKBLxpmeWtc3C++oJHK+O/ByzKiX9MkO3Wks3B9++glHAP+e 0KFw== X-Forwarded-Encrypted: i=1; AJvYcCUF9X9kJqEBhf51/91VAxtr3sV7rDndXEzDhKFaRWVHX+ADZBcySln78ywbePi1QOGjDWdfTYanHZSEm/9X@lists.postgresql.org X-Gm-Message-State: AOJu0Yw+t1xDLpGf9kb1ja4VVkESfwTKXd6F48jXVK8eEslhqqdOSEbI 2d3m2j3Zt8N58WD0HKfKg/eJVJC4QRZtlOVWsnqbWz8DDOwnx/WjULSy8QDfKXbLswiuyiITXYj 6xryCd7zaFn737T+Nmg8o5N/OaxzMGSA= X-Gm-Gg: AZuq6aKxEfsoYX6WRptVsLLs47u6YOvU9CpUw8FbiKgMlKfoGiCWlO8P/bloaYFzl7q cWQMzh1I/CpVSlIxCQKptiqSScrDEgC/EYjXxenTx7F6N6Y2r9ciZklGOmjHpOspfONb4/VUa6J oPUgcIpZtNSPvsuqGuGW2YwegfLvXNZa9xSOIQlxqTxjvbGwZxJZ/WSsew9JHbxBF+IyKd9R/I1 X/GqmRTWFkmyFMVzGef6vm6NyD7icuPQkx6qfFEwq8psFA0FqEvxC/nBSu6S2pQv9XcvBSSPs5j Q3tC1D0Pj5bgtH7pbIsE+LGPKkx6xVUvs0AJJKZRuNQVteEEWoBsnOVIMMUtr3vpgjr3vp0xm2D ErKKVV4ib0juU3pakUjRIw9ABkw== X-Received: by 2002:ac8:5f54:0:b0:4ff:7efd:54f6 with SMTP id d75a77b69052e-505d21841d3mr184379731cf.20.1770096290242; Mon, 02 Feb 2026 21:24:50 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: John Naylor Date: Tue, 3 Feb 2026 12:24:39 +0700 X-Gm-Features: AZwV_QiGbDdghC6rcahpy8di6Oq5Cur4mHQ7IVA6GD7owEQ8LkxDmEze42LwOMk Message-ID: Subject: Re: More speedups for tuple deformation To: Andres Freund Cc: David Rowley , Chao Li , PostgreSQL Developers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Feb 3, 2026 at 7:33=E2=80=AFAM Andres Freund w= rote: > It's somewhat scary to see this level of code size increase in a case whe= re > the compiler really has no information to think vectorizing really is > beneficial... I tried building on gcc 15.2 with -fno-tree-loop-vectorize, and the server .text segment was only 5kB smaller, but that may understate the impact on the decisions that get made. Maybe it's better to opt in for unrolling and vectorization? I think this option also controls whether to turn loops into libc memset/memmove etc calls. -- John Naylor Amazon Web Services