Unused item pointers - can someone explain?

Поиск
Список
Период
Сортировка
От Elmer
Тема Unused item pointers - can someone explain?
Дата
Msg-id 9ef191d5-1aec-4dc0-96d6-e45b3c0add76@a28g2000hsc.googlegroups.com
обсуждение исходный текст
Ответы Re: Unused item pointers - can someone explain?  ("Peter Childs" <peterachilds@gmail.com>)
Список pgsql-general
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?


В списке pgsql-general по дате отправления:

Предыдущее
От: Sascha Bohnenkamp
Дата:
Сообщение: Re: select with recursive support
Следующее
От: Martin Gainty
Дата:
Сообщение: Re: Read-only availability of a standby server?