Re: Index Issues & ReIndex

Andrew Sukow <creoe@shaw.ca> writes:
> 1. Big Int Indexes point to the wrong result
> 2. Duplicate quries run minutes apart return different result sets but
> then stablize to one result.

You sure you don't have hardware problems?  Generally, when someone
shows up reporting bizarre instability, it ends up being broken
hardware.  This could be a software issue, but it doesn't smell like it.

> 7. ONLY Indexes are affected.

Define what you mean by that.  How do you know it's only the indexes?

> 8. Running version Postgres 7.4.3, 300 gigs of storage space outstanding

What's the platform?  What did you compile Postgres with?

            regards, tom lane