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

From Andrew Sukow
Subject Re: Index Issues & ReIndex
Date
Msg-id 2b2eaad2b34788.2b347882b2eaad@shaw.ca
Whole thread Raw
List pgsql-general
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
>
>


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Problem when installing dbsize of PG 8.0-beta1
Next
From: Kris Jurka
Date:
Subject: Re: PostgreSQL 8.0 Feature List?