Unused item pointers - can someone explain?

From: Elmer <sebastian(dot)franek(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Unused item pointers - can someone explain?
Date: 2007-11-21 10:42:54
Message-ID: 9ef191d5-1aec-4dc0-96d6-e45b3c0add76@a28g2000hsc.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ottavio Campana 2007-11-21 11:17:13 maximum size of plpgsql function parameter
Previous Message Sascha Bohnenkamp 2007-11-21 10:29:45 Re: select with recursive support