Postgres Pro
Downloads
Home   >   mailing lists

Re: pgcon unconference / impact of block size on performance - Mailing list pgsql-hackers

From Roberto Mello
Subject Re: pgcon unconference / impact of block size on performance
Date
Msg-id CAKz==bLqmYt67Z8DRgw90t_Zqid3apHZQ3SGvOjDG3QLYcmi=A@mail.gmail.com
Whole thread Raw
In response to pgcon unconference / impact of block size on performance  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Responses Re: pgcon unconference / impact of block size on performance
List pgsql-hackers
Tree view
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 

pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: pgcon unconference / impact of block size on performance
Next
From: Michael Paquier
Date:
Subject: Re: [v15 beta] pg_upgrade failed if earlier executed with -c switch