[7.0.2] INDEX' TUPLES != HEAP' ..
От | The Hermit Hacker |
---|---|
Тема | [7.0.2] INDEX' TUPLES != HEAP' .. |
Дата | |
Msg-id | Pine.BSF.4.21.0007122000440.1325-100000@thelab.hub.org обсуждение исходный текст |
Ответы |
Re: [7.0.2] INDEX' TUPLES != HEAP' ..
|
Список | pgsql-hackers |
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, MaxLen79; 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@hub.org secondary: scrappy@{freebsd|postgresql}.org
В списке pgsql-hackers по дате отправления: