Re: URGENT: Index problems - update - please help ....

"Steve Brett" <steve(dot)brett(at)e-mis(dot)com> writes:
> i followed the instructions very carefully and get the following error when
> i try to run pg_upgrade ..

pg_upgrade hasn't worked since 7.0. Where did you find instructions
that told you to run it?

>> I added a hash index to a varchar value and when i vacuumed i got the
>> following error:
>>
>> Index customer_ha_hash: NUMBER OF INDEX' TUPLES (9176) IS NOT THE SAME AS
>> HEAP' (9181).

If you have any rows that contain NULL in the indexed column, then this
result isn't very surprising, because hash indexes don't index nulls.
(Current sources have been fixed not to issue the cross-check notice
message for hash indexes, btw.)

Personally I'd advise not bothering with hash indexes; use a plain btree
index instead. Does more, works better, doesn't have concurrency
problems.

regards, tom lane