Horton

Re: pgcon unconference / impact of block size on performance

Roberto Mello <roberto.mello@gmail.com>

View thread
From: Roberto Mello <roberto.mello@gmail.com>
To: Tomas Vondra <tomas.vondra@enterprisedb.com>
Cc: Bruce Momjian <bruce@momjian.us>, "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>
Date: 2022-06-05T00:21:07Z
Lists: pgsql-hackers 
On Sat, Jun 4, 2022 at 5:23 PM Tomas Vondra <tomas.vondra@enterprisedb.com>
wrote:

> Hi,
>
> At on of the pgcon unconference sessions a couple days ago, I presented
> a bunch of benchmark results comparing performance with different
> data/WAL block size. Most of the OLTP results showed significant gains
> (up to 50%) with smaller (4k) data pages.


Thanks for sharing this Thomas.

We’ve been doing similar tests with different storage classes in kubernetes
clusters.

Roberto

>