Re: [GENERAL] Index pg_proc_prosrc_index: NUMBER OF INDEX' TUPLES (1071)ISNOT THE SAME AS HEAP' (1070)

> Bruce Momjian wrote:
>
> > > > That will also be fixed.
> > >
> > > Do you mean to say the offending index will be auto-corrected on the fly?  That
> > > would be almost as good as preventing the root cause in the first place...
> >
> > No, it just reports the index name.  In 7.1, I think this problem will
> > go away, if not in 7.0.
>
> Is the problem well-understood?  Is there a place where I can read up on it?  This
> kind of instability is painful enough to get me thinking about trying to hack my
> distribution...

I believe it has to do with extra index tuples showing up in the index
that are not in the heap.  When the count's don't match, the problem is
reported.  I believe it only happens when the system crashes during an
index update.  I think it is harmless.  To fix it properly requires a
very sophisticated write-ahead log that is scheduled for 7.1 in about
six months.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026