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 1swjrv-005nCH-RS for pgsql-hackers@arkaria.postgresql.org; Fri, 04 Oct 2024 15:05:25 +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 1swjru-0018pl-Hm for pgsql-hackers@arkaria.postgresql.org; Fri, 04 Oct 2024 15:05:22 +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.94.2) (envelope-from ) id 1swjrt-0018pd-Gy for pgsql-hackers@lists.postgresql.org; Fri, 04 Oct 2024 15:05:22 +0000 Received: from mx0b-001b2d01.pphosted.com ([148.163.158.5]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1swjrq-002Spm-7J for pgsql-hackers@postgresql.org; Fri, 04 Oct 2024 15:05:20 +0000 Received: from pps.filterd (m0356516.ppops.net [127.0.0.1]) by mx0a-001b2d01.pphosted.com (8.18.1.2/8.18.1.2) with ESMTP id 494EpTBa017309; Fri, 4 Oct 2024 15:05:08 GMT DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ibm.com; h=from :to:cc:date:message-id:references:in-reply-to:content-type :mime-version:subject; s=pp1; bh=FypLPRQi5NNKCWjdbI93Ro2PNa4BzcS qO7uTXeLHSls=; b=QffjSEefQii/p60pnFC7Nk+IYHDJ5uEbs9WobxEvmRPMYBM JSLqC3hDTCH6X4Z615NVqDrRwy2uY4SItsBRuyCAG66LUjNxAzK9cCn3IbKBLHbM 8PGuFO1DV9+tz6HtmOe11SgETBWxLIKxdimLOnwAmfvZsvDoI+WSR7iBQkapIOyo oPywcqxqfI7vCe4Iu7wNlqQaa3YP544qu1jo41QrQ0QocukRI1wbwyVVgnh/40KZ 9fV+ApN/BHEESv0z75ZWAtj4b8j7UkSutEDGkd+yrorR6Ev3UO8GeVxGznSJ4KfX V75x/zN7a0TxN9VBj3urqfvBNhTPygRx6fk93ug== Received: from pps.reinject (localhost [127.0.0.1]) by mx0a-001b2d01.pphosted.com (PPS) with ESMTPS id 422jg30232-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Fri, 04 Oct 2024 15:05:08 +0000 (GMT) Received: from m0356516.ppops.net (m0356516.ppops.net [127.0.0.1]) by pps.reinject (8.18.0.8/8.18.0.8) with ESMTP id 494F4GrP018315; Fri, 4 Oct 2024 15:05:07 GMT Received: from nam10-dm6-obe.outbound.protection.outlook.com (mail-dm6nam10lp2101.outbound.protection.outlook.com [104.47.58.101]) by mx0a-001b2d01.pphosted.com (PPS) with ESMTPS id 422jg3022w-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Fri, 04 Oct 2024 15:05:07 +0000 (GMT) ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=D5IWPLEVtYxjMtkD0P5jgMHUNpp50K5mZpOvNQHW8C30wcAohw3Tc6uFh9Yq3p/tqeW6CNNIj/ViSRqGQwfE3AiwIkgPcZVrnawomdt2MTZz5MXBfzBdQ8pYDRRHSRh0wrYBLcYUF3jOCqfHejlNVyNxMlFuHOBIsiUcUmvYFt8+UZ3w9OhXqy+gG/eHVeqnRc98y3yDVjrSUNkJQ6kMWfM3pNIHZ7YJHXbAfmABFp4IV1UKiSYdyiUZZMo8v7GyT3a2/Kv4gRo2hNkG7W2M3ryeaeSNmybAVX9oodAEx6b6wg/14nIAA2zCHWv3ga4dXVqvjfcR9GJTq81X0woJUw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=FypLPRQi5NNKCWjdbI93Ro2PNa4BzcSqO7uTXeLHSls=; b=fYEXHpms2tURHTv0bhIXswbxMDk5OjbZoOijC5/qWAP0L9cNhnAvtbV7K6szPBTM5IqF/22NqGdDUgQxzex4HLDxUoUxxnAm8A08KjSp4d1qJaI3bgsy2ExcjfEFdOcO5imF42NPN8xGWI07smElz5LgKddzPEMl14YtSGbx0JiyXfRN+t1KYP+c2jkWk5YfrWgjqTQA2y+jRkL3UnPQzST2Enmo542yIc4IYAuUTOLToniJY0Esh13bYa1HBG2JsQby4k2dTysfKOuzZlBnER2JnQDz6U7d8dXdn+hCJ7Ftvl7GYwlrxTJeeIgOSRXw2mtLzajp2YdUd7d5wZoAxQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=in.ibm.com; dmarc=pass action=none header.from=in.ibm.com; dkim=pass header.d=in.ibm.com; arc=none Received: from CY8PR15MB5602.namprd15.prod.outlook.com (2603:10b6:930:9a::21) by MW3PR15MB4059.namprd15.prod.outlook.com (2603:10b6:303:48::19) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8005.26; Fri, 4 Oct 2024 15:05:04 +0000 Received: from CY8PR15MB5602.namprd15.prod.outlook.com ([fe80::e975:185c:340f:70ae]) by CY8PR15MB5602.namprd15.prod.outlook.com ([fe80::e975:185c:340f:70ae%7]) with mapi id 15.20.8026.019; Fri, 4 Oct 2024 15:05:04 +0000 From: Srirama Kucherlapati To: Heikki Linnakangas , Heikki Linnakangas , Bruce Momjian CC: Peter Eisentraut , Alvaro Herrera , "pgsql-hackers@postgresql.org" , Laurenz Albe , Noah Misch , Michael Paquier , Andres Freund , Thomas Munro , "tvk1271@gmail.com" , "postgres-ibm-aix@wwpdl.vnet.ibm.com" , Tom Lane Thread-Topic: [EXTERNAL] Re: AIX support Thread-Index: AQHae4rr5/ageaPz8EuxaB+VNKiBu7FCOGKAgAArgSaACn9l2IABLM4AgAADTgCAAAP8gIAABU6AgAvJNWiAAB/ogIATySEqgACu3ACAARripYAB4tSAgAAMOICABwWYgIAAB3wAgAAD0oCAAAcGgIACYnHWgAxC+/6AAz5ikoAC7ZKggAAzhgCAAAZWgIALF3TtgAAGbYCAAAc8toABabZigAAKZACACX4wBIAA83CAgAA8Eh6AAGyZAIAD7Q2AgBOpYxWABEWoAIABtJbFgAm10OGAAxsEAIAACpc/gAM2cX+AU/nKsoAASmYAgAB8EsuAAFNfAIArcUjPgACuTICAAndU4oAGmUOsgAqpmr2AACCfgIAA83KngA6qCqQ= Date: Fri, 4 Oct 2024 15:04:57 +0000 Message-ID: References: <95a44be0-b2f8-464a-8984-771d892b1cac@iki.fi> <40da8288-05fd-4028-adab-81db2092ba8c@iki.fi> <7751f9c5-e2e6-4252-a9fa-14b3e78ddec9@iki.fi> <73dafd11-32f4-4238-b374-74eb917aa7fc@iki.fi> In-Reply-To: Accept-Language: en-US Content-Language: en-IN X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-publictraffictype: Email x-ms-traffictypediagnostic: CY8PR15MB5602:EE_|MW3PR15MB4059:EE_ x-ms-office365-filtering-correlation-id: 67ab6278-7e4b-4566-e165-08dce485ed68 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|366016|7416014|1800799024|376014|10070799003|38070700018; x-microsoft-antispam-message-info: =?Windows-1252?Q?ZGUvEstAQvFuRfnqmx82awvJmm3/ARBojy5X129mp7NPCLz+1YY7pq3Q?= =?Windows-1252?Q?0oQUUxzRp/NxKSEle6/OIJJc5vBZiesk5za54pF8Pi3NTeGMNMnfB2ax?= =?Windows-1252?Q?4BA0r5Dxlr6LmfZXgVyBmM5DVJIV0R+fqCLmnzmiTbmIk5FP6D9azoDz?= =?Windows-1252?Q?wXcbgITgMizAdRUqKOXP3nXEqwgWoisnWyCstaHC0kzVxZIHMBdGToEY?= =?Windows-1252?Q?qbi20bju4mIaUkol7v+qAJ5P+mnSX3f7ETpyr7Mp2M42h78unjzcGb0G?= =?Windows-1252?Q?wJLmppgqlO1dTB5JuDvlYzatxtpO9Op0VwHcrV/LFvI1yM1ublvG9fZk?= =?Windows-1252?Q?B+G30pBygxTDGIDK28ojbh2e1SpKTXP8LkL48ZwIwiluz9SbKzj22sDY?= =?Windows-1252?Q?7cabagXXudcdV2CmbAZhpu0OtlyOoCIw9xeqhnYT7w4D889myl4nGaGA?= =?Windows-1252?Q?L1JMrLussR8nGwQg2x18P0x4RdGDEmBCO8sLnTDCfmh+qkPVkZwSx0qa?= =?Windows-1252?Q?Lps+vaTqf1Nzh5n+lslbAHSRfWZ43aKVhB6efgZwVXBTOL9t3KrELEFW?= =?Windows-1252?Q?wn3usXt+v9XbHHc81qcc4K7siDVQ+D0Q8ffHeIpe5avNpNF6yPVDWBZ3?= =?Windows-1252?Q?ihJYXlmjPD/+bl3ueSAQVwmYYZC70OKXi2UEZ65beFcTOCyXr7klRzu1?= =?Windows-1252?Q?kFwvowD7A+ItTXC9jvMEuneDIsRkVJccze1zwgH9R+9XRmOb93O9PIMo?= =?Windows-1252?Q?Y6u8ldp2Dyei/pYNLo/2iR82+bSiUJ9Ku1hGNQFQicl+mmVK+uJzSQ2L?= =?Windows-1252?Q?qWJlnddExSkCcIJGb9BN1TqgzHIVjhbxkhymvN4pEZegv0qKKEJSp5Io?= =?Windows-1252?Q?sKmuT9Sr8zbvp/sD0J/HzDp3lbU0THBMtHr7TQc1MlbqODhLfO6u1mko?= =?Windows-1252?Q?fniiCyIywvx9wJRCidYsjMzcLbE+HGz9AAEWZpexIGBuSDqJwfKagDov?= =?Windows-1252?Q?wH/sw9tZpCkOWRbkooduZYlfs15Igu1fwHUhzcY8sS2860wruBDM7r2K?= =?Windows-1252?Q?9tSBguQ2hYZ3iFfAOt2OGZ94+M0f0Iymr9OgZFetb4D8aiE9eDXO0kJP?= =?Windows-1252?Q?VjQOWUc1dQF1i2jkxWTaG8lRfDmSUPvgc1veSAl+8o7rBDADH7pVHOND?= =?Windows-1252?Q?V/9F6yDATaeSZBI5wKnkuX9EAfdw1ZzCYPqYBebVYpqQKN80nhN+W6K2?= =?Windows-1252?Q?JECgmcqongcd+PmWomvW64FKtzOLI/EpjE940NVkpEpwk7oQMyyL7neP?= =?Windows-1252?Q?r7S74odp5LpwBjB7D9gwU5IeCkWRFKFmPyoIlGPRP45GqLNfWE6+nbR3?= =?Windows-1252?Q?yft13ql3CYO8LNUnF7myvGikbgtBWMd3F2G7njRKktHo+xZtQzp6fKL9?= =?Windows-1252?Q?WuVDG1s6HYDmq+aRae3krg=3D=3D?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:CY8PR15MB5602.namprd15.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(366016)(7416014)(1800799024)(376014)(10070799003)(38070700018);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?Windows-1252?Q?GOa/eWIXMD9ZLybh4/7gHCvHR7p5vReVrHYQl5HPglW9gM7AlMBYoVBF?= =?Windows-1252?Q?QTURLsvHBNR++6YnFFFXwK6UsKhuuEExERLBUbSgKR/S9n1D9ZZMw6G2?= =?Windows-1252?Q?E80iEoek0G3Adr5/PLoeVzl0ZnbOs0Y/pYtu4sCykMJeuItCZSgsN7el?= =?Windows-1252?Q?k4D4o5OZOJU7GF/dmbiGBXtJVuaR5v2zrjP+plB0S2eeOUW0HYZGD9CV?= =?Windows-1252?Q?tQrPmYw44RWNxitY+i379zC+xP9fFozTr7fNedrvc9JCH2D7/gTmZsvw?= =?Windows-1252?Q?ucRhL2P3jm3O9LPGLkUN+7vjX9DF85f5VWBGo/f3BuyNw09UdlW68Lpb?= =?Windows-1252?Q?8Ok/6pB+BTx9JOE+esL8I/N9uYOu1jZgLcjdGxPAF4v9SrUXV+BDOKwJ?= =?Windows-1252?Q?gYvhq8SRGFPEiyFNUBk97qdl4cwDuTIqUSJsLodJCF1sGsTYz7MqfcoX?= =?Windows-1252?Q?3HFB3M4hVfyDJ0so+BbXUA12ls6/4va4VTIpizznxVFXsNbq2oQXHDoH?= =?Windows-1252?Q?Xjm0dXR6mQJx831kZHAxpv22cUajb2iDjWODj4nSqbBg4B5a2pqlcPRd?= =?Windows-1252?Q?Xx9GiirkWE3FZ4pelEarUa5fd5Ud/u5JkHiElTwVz9SlW+qw7I190Nk+?= =?Windows-1252?Q?ylldzQmBJWNdgSd3lfhxfZWP8z8/gfLC6VdetF5Jsavn3/fLChYJsXDB?= =?Windows-1252?Q?fJ9Gh2xRIPzQ7DSPqdFKZPhXQWjXPlQwFjFsqvsfwykbjb9Hx1j2d9u0?= =?Windows-1252?Q?R6twVZ9RF7V/nsUbBuTy+pgeyK7nv1IESISACMrdhPn3E6gWoYZG5zyl?= =?Windows-1252?Q?uTWvXlbeZA59cklMf3QD5Nr1Y8QlDumdMTUWu2wnCb2FmngRB8sOP8hm?= =?Windows-1252?Q?yMIqQXDkNCOR6GH3cHBruk1YRutnVqn9FgAC7NDG/zC6zYgs5MIDeClT?= =?Windows-1252?Q?D0W1cdBSAN0WJVWLsyaEJzQpcz1IbX6qjfj0VOc2mtYjbYBle4ktX1Dz?= =?Windows-1252?Q?PM29PX7LOGfgsRcLljwjjA9HbrZU7NNMLupGYFTrr5IqD8aJ8RQ71L8y?= =?Windows-1252?Q?p4Bg+sIO+f2SSUqErkKkw7ySnOxvY27cB9eBNqD7Xvjftwb3qkHUkNzt?= =?Windows-1252?Q?RY+HkUh7aYF6lrGlAb1Hqc1O6B8Xqk/JFYxzeuMlfek/hQpC5mxUO96R?= =?Windows-1252?Q?qZdu3WyHnDaklKk/YWMvKePFMSKu6zAJfBiTeHT4tfZv64JZu1aiWB2G?= =?Windows-1252?Q?7IDbKiGd7WYF7vjNVmQRdFpGO4IvoFy+XCRx00D07s8Ag11sYud0t7a1?= =?Windows-1252?Q?VKrd2EAZF5t64H35uvfQNh1W5j/2dtYxRXg6w3ST9uvVTl0a4r31pjKC?= =?Windows-1252?Q?LD6RmFCOMqhkaogEK0JUisbk7/nv9Tm43/sFrwIc3/ocwMgJOv7qFoZ3?= =?Windows-1252?Q?reVWW6Hx5BieFPbNB5vbSxDJ1B5YwJJ8WlK0/9oFh1TMLsAkG7DGEyOh?= =?Windows-1252?Q?eR1ERxOQu73R/neubp6T5Y52uJKK82uKVnWiF0gTCMALz1SnmoJ+orp5?= =?Windows-1252?Q?ykIjHQA3HZFvWq32W1pTaSeFc3IeKBITC//MO9llQXw3S8tGkRllPadw?= =?Windows-1252?Q?j75ZlyRWqmxxqejJAraKBv5xWzvQ1oABBfT/O1jVEZBoV+hIs28LBMtO?= =?Windows-1252?Q?dEe08eovgj5jg62c8jWGCiRA5hKtNxZfumlyDBarzL5xP5719rscipIj?= =?Windows-1252?Q?mWKx55sY3qp7QHEzMf+lX0gFstzjDRJke4176uym?= Content-Type: multipart/alternative; boundary="_000_CY8PR15MB5602EB54EFE30D4C21F061BEDB722CY8PR15MB5602namp_" MIME-Version: 1.0 X-OriginatorOrg: in.ibm.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: CY8PR15MB5602.namprd15.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 67ab6278-7e4b-4566-e165-08dce485ed68 X-MS-Exchange-CrossTenant-originalarrivaltime: 04 Oct 2024 15:05:04.4010 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: fcf67057-50c9-4ad4-98f3-ffca64add9e9 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: A28hhA4Oi0OZepdFN10q1IKnZ+v03SS7BlafFHB4m9pPCLLEmXk5pOvzsvUc9PCZeSyb82KEBrsAEukeGth6sw== X-MS-Exchange-Transport-CrossTenantHeadersStamped: MW3PR15MB4059 X-Proofpoint-GUID: p0S4CIoVs6akgZZDMcSjVk45zqyC2P3T X-Proofpoint-ORIG-GUID: MTOUBetrecOSPRs3td8LXwD_lnNSlWWk Subject: RE: AIX support X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.293,Aquarius:18.0.1051,Hydra:6.0.680,FMLib:17.12.62.30 definitions=2024-10-04_12,2024-10-04_01,2024-09-30_01 X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 spamscore=0 clxscore=1015 adultscore=0 bulkscore=0 mlxscore=0 lowpriorityscore=0 malwarescore=0 phishscore=0 suspectscore=0 impostorscore=0 priorityscore=1501 mlxlogscore=865 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.19.0-2409260000 definitions=main-2410040104 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_CY8PR15MB5602EB54EFE30D4C21F061BEDB722CY8PR15MB5602namp_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi Heikki and team, A few updates=85 > > Ok, if we don't need the assembler code at all, that's good. A patch = to > > introduce AIX support should not change it for non-AIX powerpc system= s > > though. That might be a good change, but would need to be justified > > separately, e.g. by some performance testing, and should be a separa= te > > patch. We ran pgbench for both the patches on powerpc Linux and below are the test results and both results are close. PPCLE sync: is the patch with the spin lock using gcc __sync* routines. PPCLE asm: is the patch with the assemble code. >> pgbench -c 100 -p 5432 -d postgres -T 180 -r -P 10 -L 10 -j 20 OS/type : PPCLE sync PPCLE asm --------------------------------------------------------- latency average : 136.257 138.552 --------------------------------------------------------- latency stddev : 234.74 238.603 --------------------------------------------------------- Initial connection time : 101.791 88.411 --------------------------------------------------------- TPS(without initial connection time) : 733.633924 721.440648 --------------------------------------------------------- No. of transactions actually processed : 132080 129893 --------------------------------------------------------- No of transactions above the 10.0 ms latency limit : 124235/132080 122183/129893 (94.060%) (94.064%) --------------------------------------------------------- Please let us know your comments. BTW we are working on the other review comments as well. Warm regards, Sriram. --_000_CY8PR15MB5602EB54EFE30D4C21F061BEDB722CY8PR15MB5602namp_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable

Hi Heikki and team,

 

A few updates=85

 

  > > Ok, if we don't need the assembler code a= t all, that's good. A patch to

  > > introduce AIX support should not change i= t for non-AIX powerpc systems

  > > though. That might be a good change, but = would need to be justified

  > > separately, e.g.  by some performanc= e testing, and should be a separate

  > > patch.

 

We ran pgbench for both the pat= ches on powerpc Linux and below are the test

results and both results are cl= ose.

 

PPCLE sync: is the patch with t= he spin lock using gcc __sync* routines.

PPCLE asm: is the patch with th= e assemble code.

 

>> pgbench= -c 100 -p 5432 -d postgres -T 180 -r -P 10  -L 10 -j 20

 

 

    OS/type = ;            : PPCLE= sync        PPCLE asm=

    ------------= ---------------------------------------------

    latency aver= age     : 136.257      &n= bsp;    138.552

    ------------= ---------------------------------------------

    latency stdd= ev      : 234.74     &nbs= p;      238.603

    ------------= ---------------------------------------------

    Initial=

    connection t= ime     : 101.791      &n= bsp;    88.411

    ------------= ---------------------------------------------

    TPS(without = initial

     connec= tion time)   : 733.633924      &nbs= p; 721.440648

    ------------= ---------------------------------------------

    No. of trans= actions

    actually pro= cessed  : 132080         =    129893

    ------------= ---------------------------------------------

    No of transa= ctions

    above the 10= .0 ms

    latency limi= t       : 124235/132080   &nbs= p; 122183/129893

     &= nbsp;           &nbs= p;        (94.060%)   &nb= sp;     (94.064%)

    ------------= ---------------------------------------------

 

 

Please let us know your comment= s.

BTW we are working on the other= review comments as well.

 

 

Warm regards,<= /o:p>

Sriram.<= /span>

=  

--_000_CY8PR15MB5602EB54EFE30D4C21F061BEDB722CY8PR15MB5602namp_--