Re: [cobalt-users] TUPLES IS NOT THE SAME AS HEAP

[Albert Csaba <maka_cs@xxxxxxxxx>]

Hi Paul,

I am having this error also. I turned to the
POSTGRESQL mailing list and there I've got some
advices.

1. You can stop running vacuumdb
2. Just ignore the message
3. Run reindex (which works only with newer versions
of PostgreSQL, and I didn't want to upgrade)
4. erase the index files and index again

I chose nr.1, this is the safest way for me.. I don't
want my RaQ to be down, if something goes wrong. I
know MySQL, but I don't really know PostgreSQL and
don't have the time now to make experiments.

If you find a fail-safe answer/method, please write
back :)

kind regards,
Csaba



--- Paul Ferwerda  wrote:
> 
> Anyone have a clue as to what this error might mean?
> I'm getting if from a cron.daily job on my RAQ3. I'm
> guessing it is from the vacuumdb script but I'm not
> sure.  Better yet, anyone know what to do to fix the
> problem?
> 
> 
> NOTICE: Index pg_class_relname_index: NUMBER OF
> INDEX' TUPLES (56) IS NOT THE SAME AS HEAP'
> (55)NOTICE: Index pg_class_oid_index: NUMBER OF
> INDEX' TUPLES (56) IS NOT THE SAME AS HEAP' (55) 
> 
> 
> Thanks,
> Paul



__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com