[OSM-dev] hstore / db schema Was: Query-Formats

[Brett Henderson]

On Thu, Mar 25, 2010 at 3:42 AM, Florian Lohoff <f at zz.de> wrote:

> On Tue, Mar 23, 2010 at 01:30:04PM +0100, Peter Körner wrote:
> > Hi
> >
> > On the osm dev-server we're playing around with the postgres-hstore
> > extension which allows us to repond to xapi-like queries, but with
> > already assembled LIESTRINGs and such neat things.
>
> Which is not per se a feature of hstore ... hstore is just another
> data type which is neat because it fits into the OSM model concerning
> tags ...
>
> I am currently building most of my applications around the osmosis
> db schema but the split into node and node_tags and way and way_tags
> is - hum - not very efficient.
>

The current schema is fairly naive in its implementation.  I hadn't heard of
hstore when implementing it.  Perhaps the current schema needs an upgrade
:-)


> This is why i would be interested in some tools to import a planet/sub
> extract
> into a more efficient db scheme which still allows to store all details
> of the osm planet (which osm2pgsql does not) but is more efficient
> concerning spatial queries.
>
> E.g. i'd like to drop way_tags and put them into a hstore tags column in
> the
> way table and then cluster the way table with the geom index on the
> linestring
> for example.
>
> Does anyone have speed/place comparisons?
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20100326/d7782a6b/attachment.html>