Re: [GENERAL] Unused item pointers - can someone explain?

2007-11-27 Thread Elmer
ating entirely new tuples at the end of table file. If I understand it correct number of unused item pointers should shrink between vacuums (but it still grows)... Regards Elmer ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

[GENERAL] Unused item pointers - can someone explain?

2007-11-22 Thread Elmer
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