Re: vacuumdb is failing with NUMBER OF INDEX TUPLES NOT THE SAME AS HEAP

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lonni Friedman <netllama(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: vacuumdb is failing with NUMBER OF INDEX TUPLES NOT THE SAME AS HEAP
Date: 2004-05-05 16:31:21
Message-ID: 7301.1083774681@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Lonni Friedman <netllama(at)gmail(dot)com> writes:
> Unfortunately, i have no clue how to replicate this. It was happening
> fairly consistantly before i upgraded from 7.3.3 to 7.3.4 (like nearly
> every vacuumdb run).

> Then nothing for a month after going to 7.3.4, and now its happening
> every vacuumdb run again.

Once the complaint starts appearing, I'd expect it to continue until you
reindex the index.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2004-05-05 16:32:39 Re: [GENERAL] cache lookup of relation 165058647 failed
Previous Message Alexander Cohen 2004-05-05 16:30:07 list types