Re: Corrupt RTREE index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Corrupt RTREE index
Date: 2004-12-13 23:25:03
Message-ID: 29270.1102980303@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greg Stark <gsstark(at)mit(dot)edu> writes:
> I have what appears to be a corrupt RTREE index.

I wonder if it's actually corrupt, or if it's just that the index
semantics don't truly match the operator. If the latter, REINDEXing
won't fix it.

As for the first theory, have you had any database crashes lately?
If so I'd write this off as a failure caused by the lack of WAL-logging
support in rtree.

As for the second theory, in this thread
http://archives.postgresql.org/pgsql-general/2004-03/msg01135.php
we concluded that the existing mapping of geometric operators onto
rtree indexes is wrong; see in particular
http://archives.postgresql.org/pgsql-general/2004-03/msg01143.php
However that discussion dealt with << and related operators, not @.
I didn't think @ was broken ... but I might have missed something.

(I was expecting bwhite to come back with a patch to fix the rtree
problems he'd identified, but he never did, so it's still an open
issue.)

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ciprian Popovici 2004-12-14 00:06:24 Multiple foreign keys on same field
Previous Message Dann Corbit 2004-12-13 23:11:11 Re: Performance differences 7.1 to 7.3