Özkan Pakdil 🦖

@lukas hey, I just saw https://pganalyze.com/blog/postgres-18-async-io very nice numbers I like it

I was also wondering, do you know any site shows #postgresql benchmark results version by version since pg 10, and of course with latest beta 18 and alpha 19 ? if exists 🤓

Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O

Postgres 18 introduces Asynchronous I/O (AIO) that can dramatically improve read performance, especially in the cloud. Learn how these changes and the new io_method setting work and see why our benchmark results show that io_uring is the recommended setting for maximizing I/O performance in Postgres 18 over the default setting 'worker'.

pganalyze
May 7 at 9:02amWeb
Show threadLukas FittlMay 8
@thejvmbender Good question! I don't know of a more general site, but Mark Callaghan has been doing some cross-version benchmarks over the years, for example: https://smalldatum.blogspot.com/2025/03/postgres-174-vs-sysbench-on-large_27.html?m=1
Postgres 17.4 vs sysbench on a large server, revisited part 2

I recently shared two posts ( here and here ) with results for sysbench on a large server using Postgres versions 10 through 17. In general...

Show threadÖzkan Pakdil 🦖May 11

@lukas I manage to make a benchmark page on GitHub

can't say it's best on the market but I can say we can run this every week and update those numbers

I am thinking to connect ec2 or oci to it what do you think ?

https://pgbench.github.io/mix/

PostgreSQL Performance Comparison

PostgreSQL Version Comparison Raw Data PostgreSQL Version Transactions Latency (ms) TPS PG12 160782 5.969 2679.027221 PG13 146415 6.555 2439.646892 PG14 157673 6.087 2627.691994 PG15 173339 5.537 2888.772886 PG16 144275 6.653 2404.463831 PG17 158929 6.039 2648.650111

PgBench
Show threadLukas FittlMay 11
@thejvmbender Nice! Not sure what you mean re: connecting EC2 or OCI to it?
Show threadLukas FittlMay 11
@thejvmbender Also, I would maybe reconsider the name, and choice of GitHub organization name. "pgbench" is what the utility is referred to, and it will confuse people looking for the utility, vs your benchmarks. Maybe "pgversionbench" or "postgres-version-bench"?