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 1uDIhu-008wca-MI for pgsql-general@arkaria.postgresql.org; Fri, 09 May 2025 08:03:47 +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 1uDIhs-009IpQ-Q8 for pgsql-general@arkaria.postgresql.org; Fri, 09 May 2025 08:03:44 +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 1uDIhs-009IpH-8Q for pgsql-general@lists.postgresql.org; Fri, 09 May 2025 08:03:44 +0000 Received: from mail-am7eur03olkn20815.outbound.protection.outlook.com ([2a01:111:f403:2e0e::815] helo=EUR03-AM7-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uDIhp-000uzc-0k for pgsql-general@lists.postgresql.org; Fri, 09 May 2025 08:03:43 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=ypIA7d8/wTZWgFF9yXEmu2MgXWrNqNd5YiIUHa8RgI2tjAbUg/94940iaqjqmZh6BIgdcW4dCGNr37VSzR4QE4D5n4jCOowBpqcI+PidrbcjJZ0kok4eD4lq6u0A6x362pC8qnuPGHp+UcQN4FfvKXO962Y/DjiHn1k9DXY6uT0dBinRa6axwKU8DoVe2fxklGj5uLDejTuyK8zEWG5NOGjPuXzw2j6LwjyMdMrMz1HfqbZPgGIkk5hGTS3onFu1WgaTzV+53jIIelDi3SRoEhsTRICzsEMabykpWQ4RQxmO/b+ORvf9Df6hFW6XIBzZ3n101Wg5SyxGjVLjo55i2g== 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=qct+kBBpusgXwP8Q2fbeMpUOWNHPogeKf+qTUzsXETg=; b=jx2wBFAvQjD87SiTCge7Yiz1CnXwV2Yohkqe7L6W8TvmjAUaSwQ5ClJ30FcoghCxb6YmpCPVZBNe3xOiRv3MVAdu7zRkLVJ/DJWmdy1K0Ku+k7lXH8NNdpOsGfsDZD7186KSieSPUY+UBmH6gLCF2B4Hbfy/rn0DOQT0Z0MY8Fqm9bWjOTRzl1Pb7M3/mm54H5KkmpJIo8WBsn0kmauhXBvyXv1jbs03TyZjlNpo6iUes/1eY8ZQ62Vk6lJWlHmGZrcBdUJzslHEu4HEnNiPw2Y8hMnh0NWbdN81j5q1HgA+cGXQqC/SLDbF7Fz0F/Iwx9N+MrS1heHgWbXLmi0Zcw== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=qct+kBBpusgXwP8Q2fbeMpUOWNHPogeKf+qTUzsXETg=; b=NXXI0xO22iRECrsAiGL8uugyUzHu8f74Ic9Wa8JQ6dB2k9xafCLgG9JYek3vNO4UDII2WVEehMavEWlXpaA5nwhTxjh2ER8Gd3YeaTMs/8RZBlDHxRbeHL83U7XkjjmHe+U2OuUvcrZMM7vnTBWi/esvHNy1FC2yXRTEe4ugGcBlXkTUqdL0yPey/sSF5/CboMv5jpUBnfcNlX8tDcyr0+yBgivQt8K+ZDiWeEMvlRyGJvIt6TLlhZOfpvFc+KVwuXATCk6NYNXQnUuK820CgexSwjYhBuwhws1gqlix1acM2oAAeCPob4N3mlgD3f62PE7k37BgJ6q/3shxdWy7yQ== Received: from DB9PR02MB9948.eurprd02.prod.outlook.com (2603:10a6:10:45c::9) by GV2PR02MB9541.eurprd02.prod.outlook.com (2603:10a6:150:da::21) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8722.25; Fri, 9 May 2025 08:03:38 +0000 Received: from DB9PR02MB9948.eurprd02.prod.outlook.com ([fe80::caeb:3de5:41b5:7728]) by DB9PR02MB9948.eurprd02.prod.outlook.com ([fe80::caeb:3de5:41b5:7728%5]) with mapi id 15.20.8722.021; Fri, 9 May 2025 08:03:38 +0000 From: SERHAD ERDEM To: =?Windows-1252?Q?=D6zkan_Pakdil?= , "pgsql-general@lists.postgresql.org" Subject: Re: Looking for pgbench Benchmark Results Across PostgreSQL Versions Thread-Topic: Looking for pgbench Benchmark Results Across PostgreSQL Versions Thread-Index: AQHbwFTqIWMPAl8VeU2boL3zo7RfP7PJ8OxO Date: Fri, 9 May 2025 08:03:37 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-publictraffictype: Email x-ms-traffictypediagnostic: DB9PR02MB9948:EE_|GV2PR02MB9541:EE_ x-ms-office365-filtering-correlation-id: 217b9348-9e6d-4dc8-b97d-08dd8ed0011a x-microsoft-antispam: BCL:0;ARA:14566002|1680799057|9000799050|15080799009|461199028|42300799018|8062599006|12050799012|9400799033|7092599006|8060799009|19110799006|15030799003|102099032|1602099012|3412199025|4302099013|440099028|4601999015|10035399007; x-microsoft-antispam-message-info: =?Windows-1252?Q?RO2u06J5jOJfZONqTh99Qjn3ygc1vh3LicftRL1njlXKXn/Z3bCgt6Yo?= =?Windows-1252?Q?+tY40kU1/7K8y9gIJHY9B8CwHX2Vlu37TQx7mspAZgkmp8mAPm/RmKX8?= =?Windows-1252?Q?9Zk9lHY7lhg92ItECErwfcRRGKVpDYFJ66SHSm/nxb4daTDp/kqjGDnR?= =?Windows-1252?Q?KI6uBVXOfL+oLZY2RL0o4Wq2VaudH+p/3ohF9xyxKIEYVCbckDQBS7TC?= =?Windows-1252?Q?BSyRQKyzD9CEja6pzV7cTJLBACprDQWq3OfqylkU7b4DufBRS227PxTV?= =?Windows-1252?Q?vQtT3xpewDgcfq3Ge9ksamlDc/OyEQrB+2BEiRzpFCjdcz5B1sNhe1q0?= =?Windows-1252?Q?xRUZR5Pd3onB45EuzOxSo4Gh7PdmVP2f5xmdFXREET8022y/PXga2fOy?= =?Windows-1252?Q?Muy8fDFPevG+aAE55BGo2otO6gGv0Hn/3Mm6uceGx3il/DQ8sXLxKWv8?= =?Windows-1252?Q?QPu8rR3nfb03V8XD/0OCS3/WAhpA8UBJys3wyHXypf5PW4rdHkym58Mr?= =?Windows-1252?Q?TroCpjYxBFNCMsPHA3cYZoS6zAO3sRLT7O90HX5gtMYSjceWgLSmWQ69?= =?Windows-1252?Q?O7OJJMxrT8obEBtDZbUFsmphU3K02yF+qyGwQtXhnCL5daZhLel12mg4?= =?Windows-1252?Q?iFbynFYiftq7Jo9e8h2jjq9elJ5dYwz6WyaT+rh9Ny6V66mjui01kkOk?= =?Windows-1252?Q?W4hlBRtjRz9IWEaMPcpRvPtAMGeIf2azPydIdbk2dY5Aw3yCus2xNUtT?= =?Windows-1252?Q?L8hnyiYMXqmlUBzzRZ5nhPsMyyCW3AEme2x9W+ucJJ+D4hJ5SZGpZV3k?= =?Windows-1252?Q?w0uuoinZSjIVdeo+ZE1W6n25+hIkeu/pjJamSy4vLM8bJtL6XFjdVch9?= =?Windows-1252?Q?d1E6SWgBj9YGVmE6NEdmgR4DBCYtS9CjuZJvTDtTkJ/CVGPYkz99gm42?= =?Windows-1252?Q?T9ZX0ef5Q1m+C3PUfDMH3ei5l9AWW0gbqT8tpXTXhfvratNy2bvoPtwF?= =?Windows-1252?Q?3guZp3zTLlWzzJwVig5sVrozpO/zkQiQ73eKIKvv+rCCRG4an1iZLt1b?= =?Windows-1252?Q?zo9lyy8/XSUrWQ6QcuUGcjApqBiO6vTcXfOEpOC+UVIzU4xV1Rjey8fH?= =?Windows-1252?Q?GqUKNkna1k1aQVuca5pISsdsPJkTIt5L4hzaT1bClhcs2PDCudXsr2nd?= =?Windows-1252?Q?ozkWXIhXaaBergv0hVCwFXOAsOOCteD6pha4mFq5C+kUtztYrZav6nY8?= =?Windows-1252?Q?QEdQEKoZIaR+CBInYDFQvqAyWvGSKK/xXYZ2+LGaWso1AuWskNFGO7Ft?= =?Windows-1252?Q?JnouyTG1ah9FQWaYpkZlKVoXGAhJV6fy5mWXHvN3jVWuB0lnh+bvLbWM?= =?Windows-1252?Q?aqsiwv+d0EZdtScTLbI/SGnFgfA2j+O6HN1Zf6WSesRcJs+yi5bwlOtP?= =?Windows-1252?Q?oniYQDuvWfzQ8hR9Vazyn0BQHxNHSFP1I4aVN6AmMHpW/Y+IUdqe7hhT?= =?Windows-1252?Q?mDHuj6x9Tsu17M8jEQB38gxPlExgHjxYveJsY/jHi86R0YlKTPw=3D?= x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?Windows-1252?Q?VSpUvm1m4hCXuIIWpQ/uqD2bLpvH74z6pobtG8mvlX5NU20Zh8B81uKP?= =?Windows-1252?Q?Tq77JEBmNDJQ+4SlrXTtag7HikSrfbAcmQcAD0DS6+yAQz+qwviuheWj?= =?Windows-1252?Q?4y7uSFWJRvXkQ34uVSVhrXYbYrfZGmZOtnQ1AXDczi1h7pvWa2bBtASp?= =?Windows-1252?Q?dlKmTmgiu/GlmiJiT250klBcdT++B7kZhJ9q767z3wMj4i/nSnlSorQd?= =?Windows-1252?Q?cEsi/K/6IANNfbfYAWZwln2sGQ2bXQGwYRZ5LmR00B1G4L+waBmfTQTs?= =?Windows-1252?Q?DxEQeijbtUqEcaDr67WZh52ex5sVpULyYGU2lvWRN09A1YkR3R9tjBXm?= =?Windows-1252?Q?b0in7l5Y9g7fEO3cbDRP4GRSA9oiPEScHW8YdO/qfzdkrQBGvLWKEMp8?= =?Windows-1252?Q?BFPnciRAk4Zv1h1vS2dDWJVjcIIp8q/OLf60Td7LrRe9FBJSZO39Dqpk?= =?Windows-1252?Q?x/eabTDXlR0rnLt3gu9fKpyQC1ha2aW2p3lhRkeaWPv4G6DMAjfgqGmO?= =?Windows-1252?Q?fKGxVoII0FdMmXXMMFDyyoePpCIoQFrGJg3ZmrS/K/jBanOoVIOU9/81?= =?Windows-1252?Q?HRJ2GWOWbCOvLZgDfMB1Z8DRQdTxWJqqV3gzpDR1D/67TUpIoyXAl9pn?= =?Windows-1252?Q?HfjEhliTSBTMEGQN041zHLDA4cby/dU/DYLQXqqx0pRL0g9zXlDh99sk?= =?Windows-1252?Q?Q8zIXk7gBfj337ZMKaHvPFd27PCFb5W0ZVBGvv8KuPThYD313uakuXP5?= =?Windows-1252?Q?8bABLx7DjKNRYH7NitXn0OJMJkrk9sCiBI/kpmwZDuQTeSHxCtAP+7OR?= =?Windows-1252?Q?qrBmxq2xEd1ud2FBFGRbGxNlc1I6FMaetUvswImFUscQje4MMF3WJq2h?= =?Windows-1252?Q?GKzj3aDJxrp6Upb8iHq3m5IgFurQPIUrcUjNnMkedl6SmhRvqZ4GeU9C?= =?Windows-1252?Q?cyI3r0kMvV7LJim1sk3tcwkmiaaZ3F2qR8va910WmnyGWwP3+vNcq6+E?= =?Windows-1252?Q?UCLjPrZ5h5HNA1JhHlYQWzdi2cGDrpyXcosguqwyFnU05Uwzhxoi6I90?= =?Windows-1252?Q?Zwax99FpvL0te6JCMG0DUhhydZh2/50YUtQdW7ae40w3K6TrUHe7i/Qv?= =?Windows-1252?Q?dJBNd6wkBHgFVojVATopmvi+VDWxW8ilgbTw/Yqd5822jUTQkmB5qYSK?= =?Windows-1252?Q?6GnqoNjx3Ypy/35VjT6kQJKhw9AgFE+Ae1id8j1ZzBKDaBZm/IPvXBBP?= =?Windows-1252?Q?xBToqJcuK8kTu1jFci73xJCg2Z1MNOVWeSFriu8YRenLt1d7Tt+a+f5O?= =?Windows-1252?Q?bHdZzg=3D=3D?= Content-Type: multipart/alternative; boundary="_000_DB9PR02MB994886F08E7142F8FB570E28A38AADB9PR02MB9948eurp_" MIME-Version: 1.0 X-OriginatorOrg: sct-15-20-7828-19-msonline-outlook-12d23.templateTenant X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: DB9PR02MB9948.eurprd02.prod.outlook.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: 217b9348-9e6d-4dc8-b97d-08dd8ed0011a X-MS-Exchange-CrossTenant-originalarrivaltime: 09 May 2025 08:03:37.9189 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: GV2PR02MB9541 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_DB9PR02MB994886F08E7142F8FB570E28A38AADB9PR02MB9948eurp_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi ,you may look at this , https://smalldatum.blogspot.com/2023/10/postgres-versions-11-12-13-14-15-an= d-16.html [https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiTQGvK-hx60qAae= 2LBQxBCnM0DOvzplpt8dtv0q29mtGvASKuop-QcubW1fmGgdfwer6SEBRoAPK1lN9ejTt9ofTcN= 2YVQA7FyH2gplVhDiiLULFvYZxykzk8NYjYqskdhEXjmqZDOvLObgNIlRjKzpzgBIl2S3Lz-V4d= nQTpm8YWOUOz0daagV3eOJApz/w1200-h630-p-k-no-nu/QPS%20relative%20to%2011.21_= %20point%20queries,%20part%201.png] Postgres versions 11, 12, 13, 14, 15, and 16 vs sysbench with a medium serv= er - Blogger I used sysbench and my usage is explained here.Postgres was configured to c= ache all tables. This benchmark used a c2-standard-30 server from GCP with = 15 cores, hyperthreads disabled, 120G of RAM, Ubuntu 22.04 and 1.5TB of NVM= e SSD with XFS (SW RAID 0 over 4 local devices). smalldatum.blogspot.com ________________________________ From: =D6zkan Pakdil Sent: Thursday, May 8, 2025 8:07 PM To: pgsql-general@lists.postgresql.org Subject: Looking for pgbench Benchmark Results Across PostgreSQL Versions Hi everyone, I=92ve been searching for a website that provides pgbench results for diffe= rent PostgreSQL versions, from 11 to 18, including the latest beta or alpha= releases. Does anyone know of such a site? Thanks! --_000_DB9PR02MB994886F08E7142F8FB570E28A38AADB9PR02MB9948eurp_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable
Hi ,you may look at this ,
https://smalldatum.blogspot.com/2023/10/postgres-versions-= 11-12-13-14-15-and-16.html
3D""
I used sysbench and my usage is explained here.Postgres was configured to c= ache all tables. This benchmark used a c2-standard-30 server from GCP with = 15 cores, hyperthreads disabled, 120G of RAM, Ubuntu 22.04 and 1.5TB of NVM= e SSD with XFS (SW RAID 0 over 4 local devices).
smalldatum.blogspot.com


From: =D6zka= n Pakdil <ozkan.pakdil@gmail.com>
Sent: Thursday, May 8, 2025 8:07 PM
To: pgsql-general@lists.postgresql.org <pgsql-general@lists.= postgresql.org>
Subject: Looking for pgbench Benchmark Results Across PostgreSQ= L Versions
 

Hi everyone,

I=92ve been searching for a website that provi= des pgbench results for different PostgreSQL versions, from 11 to 1= 8, including the latest beta or alpha releases.

Does anyone know of such a site?

Thanks!

--_000_DB9PR02MB994886F08E7142F8FB570E28A38AADB9PR02MB9948eurp_--