[7.0.2] INDEX' TUPLES != HEAP' ..

Odd .. why is heap reporting 5899, when count() only reports 2951?

globalmatch=# select count(gid) from images;
count
-------
2951
(1 row)

globalmatch=# create index images_gid on images using btree ( gid );
CREATE
globalmatch=# vacuum verbose analyze images;
NOTICE: --Relation images--
NOTICE: Pages 56: Changed 0, reaped 0, Empty 0, New 0; Tup 5899: Vac 0, Keep/VTL 2948/0, Crash 0, UnUsed 0, MinLen 51, MaxLen 79; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.04s/0.00u sec.
NOTICE: Index images_gid: Pages 8; Tuples 2951. CPU 0.00s/0.00u sec.
NOTICE: Index images_gid: NUMBER OF INDEX' TUPLES (2951) IS NOT THE SAME AS HEAP' (5899).
Recreate the index.
VACUUM

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org