Re: compress method for spgist - 2 - Mailing list pgsql-hackers

From Paul Ramsey
Subject Re: compress method for spgist - 2
Date
Msg-id CACowWR2LhVi4JHEVV=PYzLSyBfnpMd5+bhr2R8t5vzs0o79Ndw@mail.gmail.com
Whole thread Raw
In response to Re: compress method for spgist - 2  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Responses Re: compress method for spgist - 2  (Heikki Linnakangas <hlinnaka@iki.fi>)
List pgsql-hackers
On Wed, Feb 25, 2015 at 6:13 AM, Heikki Linnakangas
<hlinnakangas@vmware.com> wrote:
> In the original post on this, you mentioned that the PostGIS guys planned to
> use this to store polygons, as bounding boxes
> (http://www.postgresql.org/message-id/5447B3FF.2080406@sigaev.ru). Any idea
> how would that work?

Poorly, by hanging boxes that straddled dividing lines off the parent
node in a big linear list. The hope would be that the case was
sufficiently rare compared to the overall volume of data, to not be an
issue. Oddly enough this big hammer has worked in other
implementations at least passable well
(https://github.com/mapserver/mapserver/blob/branch-7-0/maptree.c#L261)

P.



pgsql-hackers by date:

Previous
From: Mike Rylander
Date:
Subject: Re: xpath changes in the recent back branches
Next
From: Marco Nenciarini
Date:
Subject: Re: File based Incremental backup v8