Horton

Re: pgcon unconference / impact of block size on performance

Tomas Vondra <tomas.vondra@enterprisedb.com>

View thread
From: Tomas Vondra <tomas.vondra@enterprisedb.com>
To: Roberto Mello <roberto.mello@gmail.com>
Cc: Bruce Momjian <bruce@momjian.us>, "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>
Date: 2022-06-05T09:51:32Z
Lists: pgsql-hackers 

On 6/5/22 02:21, Roberto Mello wrote:
> On Sat, Jun 4, 2022 at 5:23 PM Tomas Vondra
> <tomas.vondra@enterprisedb.com <mailto: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. 
> 

Can you share some of the results? Might be interesting, particularly if
you use network-attached storage (like EBS, etc.).


regards

-- 
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company