Hi,
On 2021-07-19 16:49:15 -0700, Andres Freund wrote:
> E.g. for
>
> select prepare(
> 1000000, -- max block
> 20, -- # of dead tuples per page
> 10, -- dead tuples interval within a page
> 1 -- page inteval
> );
> attach size shuffled ordered
> array 69 ms 120 MB 84.87 s 8.66 s
> intset 173 ms 65 MB 68.82 s 11.75 s
> rtbm 201 ms 67 MB 11.54 s 1.35 s
> tbm 232 ms 100 MB 8.33 s 1.26 s
> vtbm 162 ms 58 MB 10.01 s 1.22 s
> radix 88 ms 42 MB 11.49 s 1.67 s
>
> and for
> select prepare(
> 1000000, -- max block
> 10, -- # of dead tuples per page
> 1, -- dead tuples interval within a page
> 1 -- page inteval
> );
>
> attach size shuffled ordered
> array 24 ms 60MB 3.74s 1.02 s
> intset 97 ms 49MB 3.14s 0.75 s
> rtbm 138 ms 36MB 0.41s 0.14 s
> tbm 198 ms 101MB 0.41s 0.14 s
> vtbm 118 ms 27MB 0.39s 0.12 s
> radix 33 ms 10MB 0.28s 0.10 s
Oh, I forgot: The performance numbers are with the fixes in
https://www.postgresql.org/message-id/20210717194333.mr5io3zup3kxahfm%40alap3.anarazel.de
applied.
Greetings,
Andres Freund
