On Wed, Nov 20, 2024 at 1:26 AM Guillaume Lelarge <[email protected]>
wrote:
> OK, but I'm not sure which example I should pick to add dirtied and
> written shared buffers. It looks kinda artificial. Should I choose one
> randomly?
>
It will be artificial, but I think that's ok: anyone running it on their
own will be getting different numbers anyway. I was looking at the "14.1.2
EXPLAIN ANALYZE" section in perform.sgml. Here's some actual numbers I got
with some playing around with concurrent updates:
Recheck Cond: (unique1 < 10)
> Heap Blocks: exact=5
> Buffers: shared hit=2 read=5 written=4
...
> Planning:
> Buffers: shared hit=289 dirtied=9
Cheers,
Greg
