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 1w4dCs-002O2Z-36 for pgsql-hackers@arkaria.postgresql.org; Mon, 23 Mar 2026 11:12:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w4dCq-00HDRp-1n for pgsql-hackers@arkaria.postgresql.org; Mon, 23 Mar 2026 11:12:24 +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 1w4dCq-00HDRg-0l for pgsql-hackers@lists.postgresql.org; Mon, 23 Mar 2026 11:12:24 +0000 Received: from mail-dy1-x1332.google.com ([2607:f8b0:4864:20::1332]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w4dCo-00000000fOx-0ThE for pgsql-hackers@postgresql.org; Mon, 23 Mar 2026 11:12:24 +0000 Received: by mail-dy1-x1332.google.com with SMTP id 5a478bee46e88-2c0c955a481so2484946eec.1 for ; Mon, 23 Mar 2026 04:12:22 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774264340; cv=none; d=google.com; s=arc-20240605; b=f4Za8SGFLhxuExbQauJXMMDUkAJhYv0qRbpsyofI6rjd63FZ2s/C6yjukyBZQL8596 ztXsaXQr0VIPYYb8xSM5K8TqSWwQlBgpDW3oJbjCgk6lOxqI7axHqE9+hbDUE05GZMny SM02DnkOIKVCX9t7ZJNLN6hmYXzDspjbj2Ng2kT73DQpQGVK8YVY1HpfoBEORhyinvR8 qHQ/QtLF8D3CFUlncw44CQ3B61tukGheSOV2rho7IQjXS8/+cM0Fi6/v6U6dv2wuaMUq ccRmVrnY0Lor3ggLxTBGxkO1kdnUGHmA3Ng8ihcUvIRsZrkAjcTts/dj5tssB0MhGzvw ZC6w== 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=MBYNH6iL3bZrpMSsYyBQFpftgKvFU+CLZNbu1EVXhYQ=; fh=Mq3fbjWANyjsHR7ztQujemJlZr02mcf3+PDDCxSFLBY=; b=DTSdOT42/lpJs5UrlRQVLEA3ssvIU+x3aJ/QUlL042ADq/lZehNkJwosQkwRPB7/sQ l9/xHQZx1X9HEKGiU7TUFfVlKc41d7A6vg0JM+JkvZVdBRd+E+TX+D8aVl4GuhWmuqfN 4cCKs5FoMVSvrLbweRa3RO1WCpUpqHVQfMKZrmOVr9/CPNui+imi+ih7QYYi0c95XKJv 5yWlkYoORtrsNWTEB03DdmPPpW057Y8lj6CGy6+nqzJk68T1ASxzqay7+m1Cra+vuNWn 4dH0Usrzbsc375RDH6cMvKj+m/gFdbKc2Yn5hdrSuD1ZPKRq5BdvVrXY2vx1zTrdJ8zq GfFA==; darn=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=1774264340; x=1774869140; 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=MBYNH6iL3bZrpMSsYyBQFpftgKvFU+CLZNbu1EVXhYQ=; b=Vc6na8bBODJ9lIy7NPtf/uAsr7/gKRtu0RUuVQ+k5rfavRyTd3PbTRwyGh8bwXz/M9 OkTQDupi/IjUtiHAluY2i7jc11S2xH2LD7bhY6V3J79FJfYlFNppoRkQiykMlHSGXehu GcQdjl05YXpQqvRd9mFPjZvkU+qGK54clxRiyNveq8FOUhDAuhZ6WIK0tBFfRDIGBjVo TA9x79Sg/Yz6n61lw+D8E/JwNLOvYjKp0EyTJ6CpSvCmgn1Ly68MolqQQAebxbSU+DBd X33jj91DuvBTb1p3N/a07lSvgXwfp1I/QsUik2Wrpgnai3EATRihs3dZGzM6UOWMp+ct mj8A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774264340; x=1774869140; 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=MBYNH6iL3bZrpMSsYyBQFpftgKvFU+CLZNbu1EVXhYQ=; b=tEuis0fpAIjWEXNKWKmRZ7Lkb3DRt2XT+h6M+/ApYvlR8qZhtqVA82kH3WN1+iowgj PlKtUZI5bo6WIyJf6vGPWDFk//oipHNGax1hcz8o1zV8vWnu3QRi89uo2OBcPDI9T7Kx egSmm6bIu9RYLhTHK/qAF+5j5X4uYmsZUbhksQI7rUjFVtYUYz92/7Rvm9O8QF/O7D4Z oVBMeCAQaCjJIc9v9wca7prKkvRDwq1JSDu8QsCFbQXKpsa/YN3GRR6BFWf1DUChisy2 twzXxQ/aVNXX5YNlsC0HzyeEFvlDu0hvRzQwF2nTMlp9tbeKr6Pkah0qwKlYJCj3ztst XuhQ== X-Forwarded-Encrypted: i=1; AJvYcCVyE3XKCWKdQ/PfjNo9mwvvFa5CjhETEcLxyMor5P6U8HU0QB5SFq5HHxWIKjSt7oSSrnnrVcyo1nbZ1lQ4@postgresql.org X-Gm-Message-State: AOJu0YxSAjWguAJRIu9vAgD4uXQOluydur4siuav086rx1OFFyxc4eMg 1asSa/tn3QIj2NkPvoFZG7fIOO86Eeld7Nqn7GlCZ5J/UXjydgP9EfRzEdmkqr51wg1OG6pIbAo dpnmZRSki1OlXsFTBMw8qHAHJu05amdk= X-Gm-Gg: ATEYQzz/4Q4yE+GDSmq5rCAaYbQw6KhlUEz7WshHApx1107onSF4uFRhvJmBmm+RNcf aDgBsPRo7oeXj2eeSgx91VHR8jLHuDhsCl9bD0COo//YqaG21em+HjH5akWOr9ilh17A3Xj9TBq bmlRGVxD6XxArMctGYYQahBAfXuzuJ0j2Z7GNp80wA2pzEHSwA0vKA5w4cKBKBl45ClXYpLECEJ u0BIcvKbEwviB8MAspl2fN6dqzRMWwQebE3jgUPQo6fQz6OLH0Xl3QI0gSDYxVBhQKNQPSnnH3l gOa4dLo= X-Received: by 2002:a05:693c:4152:20b0:2be:8216:57db with SMTP id 5a478bee46e88-2c109585270mr4063309eec.3.1774264340152; Mon, 23 Mar 2026 04:12:20 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ranier Vilela Date: Mon, 23 Mar 2026 08:12:08 -0300 X-Gm-Features: AQROBzCsA8z6ra9XIQDGYhFHYyCC3acjidQHuTw1l19H-3hDLxDT23awxPocoKM Message-ID: Subject: Re: Avoid multiple calls to memcpy (src/backend/access/index/genam.c) To: lakshmi Cc: Bryan Green , Pg Hackers Content-Type: multipart/alternative; boundary="000000000000bb85c8064daf1b18" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000bb85c8064daf1b18 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi. Em seg., 23 de mar. de 2026 =C3=A0s 01:42, lakshmi escreveu: > Hi, > > Thanks for the reply. > > Here are the details of my test setup. > > I ran the tests on Debian Linux (6.1.0-10-amd64, x86_64) on an AMD Ryzen = 5 > 7535U (6 cores / 12 threads). > Thanks for the tests. > > The PostgreSQL version was 19devel, built from source using gcc 12.2.0 > with enable-debug. > > For benchmarking, I used pgbench with the following command: > pgbench -p 55432 -d postgres -c 10 -j 4 -T 60 > > The database was initialized with scale factor 1 (pgbench -i). I ran > multiple iterations for both the original and patched versions and compar= ed > TPS and latency across runs. > > All tests were done on the same system under similar conditions. > > Please let me know if you=E2=80=99d like me to try any other scenarios or= provide > more details. > Could you repeat the tests without enable-debug? best regards, Ranier Vilela --000000000000bb85c8064daf1b18 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi.

Em seg., 23 de mar. de 2026 = =C3=A0s 01:42, lakshmi <lakshm= igcdac@gmail.com> escreveu:
Hi,

Thanks for the reply.
Here are the details of my test setup.

I ran the tests on Debian Li= nux (6.1.0-10-amd64, x86_64) on an AMD Ryzen 5 7535U (6 cores / 12 threads)= .
Thanks for the tests.=C2=A0

The PostgreSQL ve= rsion was 19devel, built from source using gcc 12.2.0 with enable-debug.
For benchmarking, I used pgbench with the following command:
pgbenc= h -p 55432 -d postgres -c 10 -j 4 -T 60

The database was initialized= with scale factor 1 (pgbench -i). I ran multiple iterations for both the o= riginal and patched versions and compared TPS and latency across runs.
<= br>All tests were done on the same system under similar conditions.

= Please let me know if you=E2=80=99d like me to try any other scenarios or p= rovide more details.
Could you repeat the tests = without enable-debug?

best regards,
Rani= er Vilela
--000000000000bb85c8064daf1b18--