On Sat, Jun 4, 2022 at 6:23 PM Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)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.
>
Wow. Random numbers are fantastic, Significant reduction in sequential
throughput is a little painful though, I see 40% reduction in some cases if
I'm reading that right. Any thoughts on why that's the case? Are there
mitigations possible?
merlin