Hello,
I vacuumed one of my database tables. In vacuum output I saw the
following information about unused item pointers:
There were 19310 unused item pointers.
As I understand It means that my table's file consists 19310 free
tuple pointers.
After some minutes I run vacuum again. It was quite unexpected for me
that number of unused item pointers was increased to 19351. I thought
unused item pointers are used in first place when new tuples versions
are created but this example makes me think I am wrong. Can someone
explain this to me?
