Alvaro Herrera <alvhe...@commandprompt.com> writes: > I wonder if it would be worthwhile to build some sort of tool to scan > the heap and ensure that there are index entries for all heap items, > just to test the hypothesis. Not that this would enlighten on the > source of the actual problem.
Seems like the hypothesis could be proven or disproven just by counting the heap and index entries while the DB is otherwise idle. It used to be that VACUUM VERBOSE was sufficient for that sort of cross-check ... but I'm not totally sure what push-ups are required nowadays to prevent it from deciding that it's smarter than you are so it needn't scan the whole table. Is VACUUM FREEZE VERBOSE still trustworthy for this? regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers