Re: Index Issues & ReIndex - Mailing list pgsql-general

From Andrew Sukow
Subject Re: Index Issues & ReIndex
Date
Msg-id 2a1a6e92a1e895.2a1e8952a1a6e9@shaw.ca
Whole thread Raw
Responses Re: Index Issues & ReIndex  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Greetings,

We're running a system with tables that range from 300,000 to 60 Million records.  Our indexes seem to be having
issues. Let me please describe the symptoms. 

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.
3. Vacuum verbose shows nothing and fixes nothing (haven't done vacuum full cause the tables can be huge around 60
Millionrecords) 
4. Analyze fixes nothing
5. REINDEX fixes the issue sometimes and removes the specific result we were looking for others.  IE: Makes the issue
goaway OR deletes the row. 
6. REINDEX fix lasts until we insert more rows at which time the error will show up again.
7. ONLY Indexes are affected.
8. Running version Postgres 7.4.3, 300 gigs of storage space outstanding

Thanks for any input on what you think the issue may be,

Andrew


pgsql-general by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: Autoincremental value
Next
From: Tom Lane
Date:
Subject: Re: Index Issues & ReIndex