[postgis-users] Broken r-tree semantics

strk at refractions.net strk at refractions.net
Sat Jun 25 04:55:48 PDT 2005


I've back-ported the patches to the 0.9 branch.
--strk;

On Fri, Jun 24, 2005 at 12:11:00PM -0400, Bill Binko wrote:
> On Fri, 24 Jun 2005 strk at refractions.net wrote:
> 
> > Hello users!
> > 
> > Reference:
> > http://archives.postgresql.org/pgsql-hackers/2005-06/msg01108.php
> > 
> > A bug in r-tree semantics has been found and fixed.
> > We ported the fix to postgis, which is also affected by
> > it. Basically in some cases an index scan would fail
> > catching some records that would be coutch by a
> > sequential scan. 
> > 
> > Now:
> > - Do you think it's worth porting the patch to the 0.9 branch ?
> 
> Sounds like the query planner can choose to do an index scan without 
> user's knowledge, correct?  So people who are using 0.9, but who's data 
> count is low may not see the error now, but will as their tables grow?
> 
> I think if that's the case, then you need to either specifically tell 
> everyone to stop using 0.9 or back-port (and I'd recommend back-porting).
> 
> > - Did anyone experienced this problem ?
> 
> I don't think so.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users



More information about the postgis-users mailing list