Looking for pgbench Benchmark Results Across PostgreSQL Versions

Started by Özkan Pakdil11 months ago3 messagesgeneral
Jump to latest
#1Özkan Pakdil
ozkan.pakdil@gmail.com

Hi everyone,

I’ve been searching for a website that provides pgbench results for
different PostgreSQL versions, from 11 to 18, including the latest beta or
alpha releases.

Does anyone know of such a site?

Thanks!

#2Daniel Gustafsson
daniel@yesql.se
In reply to: Özkan Pakdil (#1)
Re: Looking for pgbench Benchmark Results Across PostgreSQL Versions

On 8 May 2025, at 22:07, Özkan Pakdil <ozkan.pakdil@gmail.com> wrote:

Hi everyone,
I’ve been searching for a website that provides pgbench results for different PostgreSQL versions, from 11 to 18, including the latest beta or alpha releases.
Does anyone know of such a site?

There has been work towards such a site, with the code listed on the
related-projects page on the website (see "PostgreSQL Performance Farm"):

https://www.postgresql.org/developer/related-projects/

As far as I know it hasn't materialized yet though, so anyone interested can
join the project and help out.

--
Daniel Gustafsson

#3SERHAD ERDEM
serhade@hotmail.com
In reply to: Özkan Pakdil (#1)
Re: Looking for pgbench Benchmark Results Across PostgreSQL Versions

Hi ,you may look at this ,
https://smalldatum.blogspot.com/2023/10/postgres-versions-11-12-13-14-15-and-16.html
[https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiTQGvK-hx60qAae2LBQxBCnM0DOvzplpt8dtv0q29mtGvASKuop-QcubW1fmGgdfwer6SEBRoAPK1lN9ejTt9ofTcN2YVQA7FyH2gplVhDiiLULFvYZxykzk8NYjYqskdhEXjmqZDOvLObgNIlRjKzpzgBIl2S3Lz-V4dnQTpm8YWOUOz0daagV3eOJApz/w1200-h630-p-k-no-nu/QPS%20relative%20to%2011.21_%20point%20queries,%20part%201.png]&lt;https://smalldatum.blogspot.com/2023/10/postgres-versions-11-12-13-14-15-and-16.html&gt;
Postgres versions 11, 12, 13, 14, 15, and 16 vs sysbench with a medium server - Blogger<https://smalldatum.blogspot.com/2023/10/postgres-versions-11-12-13-14-15-and-16.html&gt;
I used sysbench and my usage is explained here.Postgres was configured to cache 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 NVMe SSD with XFS (SW RAID 0 over 4 local devices).
smalldatum.blogspot.com

________________________________
From: Özkan 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 PostgreSQL Versions

Hi everyone,

I’ve been searching for a website that provides pgbench results for different PostgreSQL versions, from 11 to 18, including the latest beta or alpha releases.

Does anyone know of such a site?

Thanks!