Re: vacuumdb is failing with NUMBER OF INDEX TUPLES NOT THE SAME AS HEAP - Mailing list pgsql-general

From Tom Lane
Subject Re: vacuumdb is failing with NUMBER OF INDEX TUPLES NOT THE SAME AS HEAP
Date
Msg-id 8238.1083779801@sss.pgh.pa.us
Whole thread Raw
In response to vacuumdb is failing with NUMBER OF INDEX TUPLES NOT THE SAME AS HEAP  (Lonni Friedman <netllama@gmail.com>)
Responses Re: vacuumdb is failing with NUMBER OF INDEX TUPLES NOT THE SAME AS HEAP  (Lonni Friedman <netllama@gmail.com>)
List pgsql-general
Lonni Friedman <netllama@gmail.com> writes:
> On Wed, 05 May 2004 12:31:21 -0400, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Once the complaint starts appearing, I'd expect it to continue until you
>> reindex the index.

> That's exactly what happens.  It consistantly errors until reindexed.
> Any suggestions?  thanks.

You are seemingly triggering some sort of bug in the backend's
large-object code, causing extra index entries to be made ...
but I sure haven't the foggiest idea how that would happen.

Perhaps you could look at the parts of your application code that work
with large objects and see if you are doing anything "off the beaten
track" that might suggest a way to trigger the bug reproducibly.
I'm sure we could fix it if we could see it happening.

            regards, tom lane

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Load Balancing and Backup
Next
From: Steve Atkins
Date:
Subject: Re: Load Balancing and Backup