Tom,
We have tested our ram, and our previous build has the exact same hardware which is stable but this does not rule out
hardware. I lean towards software to the fact that we are only finding the instability in the indexes. The four
millionrows we write per day are perfectly fine, but just cause huge 6 gig processes randomly from the index being
brokendown. An hour long reindex usually fixes it until we insert more items.
We do get resulting errors like "root page level 1 expected 3" some times on the index as well. Reindex fixes it.
We're running Gento which was just compiled 1 month ago up to date with a just brand newly compiled C compiler.
Thanks,
Andrew
----- Original Message -----
From: Tom Lane <tgl@sss.pgh.pa.us>
Date: Friday, August 13, 2004 4:57 pm
Subject: Re: [GENERAL] 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
>
> ---------------------------(end of broadcast)----------------------
> -----
> TIP 8: explain analyze is your friend
>
>
