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