Re: GiST penalty functions [PoC] - Mailing list pgsql-hackers

From Andrew Borodin
Subject Re: GiST penalty functions [PoC]
Date
Msg-id CAJEAwVG=Ws8rJaeG14wCj5rzBN_5L_v+xM87XzEmaO9eqbh3Lw@mail.gmail.com
Whole thread Raw
In response to Re: GiST penalty functions [PoC]  (Heikki Linnakangas <hlinnaka@iki.fi>)
Responses Re: GiST penalty functions [PoC]  (Andrew Borodin <borodin@octonica.com>)
List pgsql-hackers
Oh, sorry, made one more attemp and now I see your algorithm differently.

So you propose to use oE and oV as a markers of borders for what I call Realm.
But there may be very little significant bits in one of this ranges.
pg_sphere and PostGiS extensions tried to use 1 as a marker, with
alike formula. And that generated not a good tree.
Here's how they done it
https://github.com/postgis/postgis/commit/9569e898078eeac8928891e8019ede2cbf27d06f

I'll try to compose a patch for your formula later, I think we should
just try and see, it is easier than to reason about digital floating
points.

Best regards, Andrey Borodin, Octonica & Ural Federal University.



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: GiST penalty functions [PoC]
Next
From: Simon Riggs
Date:
Subject: Re: Optimization for lazy_scan_heap