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.94.2) (envelope-from ) id 1u87vZ-00DyOk-0Q for pgsql-hackers@arkaria.postgresql.org; Fri, 25 Apr 2025 01:32:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u87vX-005TA0-3Y for pgsql-hackers@arkaria.postgresql.org; Fri, 25 Apr 2025 01:32:27 +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.94.2) (envelope-from ) id 1u87vW-005T9s-Pi for pgsql-hackers@lists.postgresql.org; Fri, 25 Apr 2025 01:32:27 +0000 Received: from mail-oi1-x233.google.com ([2607:f8b0:4864:20::233]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u87vU-001skm-0p for pgsql-hackers@postgresql.org; Fri, 25 Apr 2025 01:32:27 +0000 Received: by mail-oi1-x233.google.com with SMTP id 5614622812f47-3fa9d872f5fso33787b6e.1 for ; Thu, 24 Apr 2025 18:32:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1745544743; x=1746149543; darn=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=OtojMVXZ/mONrT4+9Yt1D6gnzwesUs1B0IhzS8j9Xt4=; b=NGqdqpQ388qpnt1KHMZ0/ja0FoqrkEhB1TiQYcUgeG4TfwfxXPLK4S2IF6jRYddCoY twgTG06anS9cySslHj5/u/NCCn/rUnd3siAVpbO/b0QAE0H2xHutCilL+eHZO/y5U3uC OGDofavld70dm28rxBlYoDRMo1P2qJ4kNOUZUhv+xvCCiw85StDHP8BMTuKcEQDf2cWC jOnr5OYsEHY8v92a0R4BdRIdqEDXP64U8Zj+Ot4y8vRleRxnv5cDqX+Z2ZfBWnVTYloX /S870/MaPEuMLD6nX8irX/Jn7KRiLnsHE4quDuZSyyQrkWJMQbtIc/nYJvJr8sPHXTnP jt7Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1745544743; x=1746149543; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=OtojMVXZ/mONrT4+9Yt1D6gnzwesUs1B0IhzS8j9Xt4=; b=hZbUGKzUd07A71JfCcfoiCNyqN93LQNxPnTgT49GBseMKs3MqxonXILM/lJC5/6uUq ZFdHmh3FMPosXlatTtp3REAP4QnStFP+v5UIoNqfjjg34cv/4i1vf2F8E+9TeoCx5SAR uyjhUIlMPKoK8gZ9uM2GDTYpsxmgePT703taPtz1DyJs9GVPryMYFuOIPEXguFowhzcZ ASVUL9XCZ6AQpGI+SvNi6V1VZaDE8tiZ9i7BnZyxTZ7SUvIQI6zEVDVyaPa0UyPdJLFO UOYzraGeyOQ/FPfJvpd+SoFy9eSCxHAhLJsDWuSIkIuEi4cbQNDmUZ8Qh601Mlxo0fc5 5u+g== X-Forwarded-Encrypted: i=1; AJvYcCWKKI07zFMvbnzQ804+jkfDFaNsjcbT7o+uLzL+T5iS1v/f8p7TYf4eaaQhf82ERqMtKUKvkY+FIhStdsrE@postgresql.org X-Gm-Message-State: AOJu0YwilVYbZ2svifrPW3njJcy4cbHoshQZ8DCammKdw+2nbknYAciH V/lcUtwFzXmNlXLYWRwK2LhwY64lQGbsU++XdahWIKlGR7Nm7uIdLIPhEXeibQcgS/8tjggCA2K 8RGbErzkD7PWgEcgvP4+FmWiKCKk= X-Gm-Gg: ASbGncuZd11QL9VcUtmNzT+u3zOqfJmS2IdcUzX/8sMtAfv0/tHth/bzAmJRGvjqevO 2Zew0z5pGGtFW5EG3fzlWU5cI6YVyADfizdhfvL+mU0o+z4kqL1y3deS6mzElWz0AuiJetzeyOf /CF6vA+UE5XXqHcKjmePcjBBDQLwARIM58ovzKJIVfEpq1I3xnywwbUpdPUpTk/l/FdPo= X-Google-Smtp-Source: AGHT+IGdCj2zdnwZrzAjtpTWuidOn4e6tah3baYrRyjeyGOqYPbMh+5NnXl9SLaPHvfZyBKVD7LQW4fq7hDaVVALHws= X-Received: by 2002:a05:6808:1582:b0:3f4:9c5:8816 with SMTP id 5614622812f47-401f2ae6b48mr86299b6e.6.1745544743234; Thu, 24 Apr 2025 18:32:23 -0700 (PDT) MIME-Version: 1.0 References: <6e6ce337-93b9-4922-9a89-be2133738fe6@iki.fi> <19422eb3-54dc-4afb-8046-5eee906edacd@iki.fi> In-Reply-To: <19422eb3-54dc-4afb-8046-5eee906edacd@iki.fi> From: Thomas Munro Date: Fri, 25 Apr 2025 13:31:46 +1200 X-Gm-Features: ATxdqUGGWSNWSd33m4WdTCUVCI-4K5hrF2LqBpVwtwgim2bHAdnOMwCmPO9m5gU Message-ID: Subject: Re: AIX support To: Heikki Linnakangas Cc: Srirama Kucherlapati , "pgsql-hackers@postgresql.org" , Robert Haas , Bruce Momjian , Peter Eisentraut , Alvaro Herrera , Laurenz Albe , Noah Misch , Michael Paquier , Andres Freund , "tvk1271@gmail.com" , Tom Lane , Tristan Partin , wenhui qiu , "postgres-ibm-aix@wwpdl.vnet.ibm.com" 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 Mon, Apr 7, 2025 at 10:04=E2=80=AFPM Heikki Linnakangas wrote: > I'm surprised how big the difference is, because I actually expected the > compiler to detect the memory-zeroing loop and replace it with some > fancy vector instructions (does powerpc have any?). It certainly does, and we've played with explicit AltiVec vectorisation before with the idea that our abstraction over x86 and ARM instructions could be extended to POWER, but that was just trying stuff and learning while wondering if those abstractions are general enough and how well all the instructions match up. No one with modern hardware and a vested interest has seriously investigated it. That's independent of automatic vectorisation done by the compiler or libc, and I guess it would not really be AIX-specific since it would also apply to Linux on POWER. One of those patches is linked from this small list of "ideas for a future PostgreSQL/AIX maintainer": https://wiki.postgresql.org/wiki/AIX