| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Andrew Sukow <creoe(at)shaw(dot)ca> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Index Issues & ReIndex |
| Date: | 2004-08-13 23:57:59 |
| Message-ID: | 29371.1092441479@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Andrew Sukow <creoe(at)shaw(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon@2ndquadrant.com | 2004-08-14 00:50:24 | Re: Re: We have got a serious problem with pg_clog/WAL synchronization |
| Previous Message | Tom Lane | 2004-08-13 23:29:43 | Re: Re: We have got a serious problem with pg_clog/WAL synchronization |