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.
Graham. On 17 February 2012 11:36, Stephan Knauss <o...@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. > > Stephan > -- Graham Jones Hartlepool, UK.
_______________________________________________ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk