[OSM-talk] osm2pgsql hstore (was: Wind turbines no longer rendered on mapnik layer)
grahamjones139 at gmail.com
Fri Feb 17 11:43:52 GMT 2012
Thanks - I will give it another try - I have got a computer running Ubuntu
11.10, which has Postgres 9.1.2. I will create a second database with an
hstore and see how it compares.
On 17 February 2012 11:36, Stephan Knauss <osm at stephans-server.de> wrote:
> Komяpa writes:
>> - is a database generated by osm2pgsql with an hstore expected to perform
>>> similarly to one without?
>> It performs at the same speed for me.
>> Of course you're not supposed to use hstore for every tag, but just
>> for those on highest zoom levels, where spatial indexes are used
>> mostly, not indexes for other columns.
> if you are using Postgres 9.1 you are advised to update to 9.1.2. There
> was a bug introduced that prevented index usage. For example testing for a
> tag like
> SELECT * from table WHERE hstore ? tag
> did not use an index and could make a query horribly slow. We experienced
> this on Toolserver.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the talk