Thomas Ineichen wrote: > to see what keys there are for rendering on my bicycle map, I query > the db for %cycle%: I think the problem is that the planner is doing a sequential scan first to get all keys.
In case you find a fast way to get all distinct keys fist you can use this filtered with your %LIKE% as an input to your following query counting the number of keys. Are all your your keys starting with cycle or is it a substring search for keys? In the first case the new hstore import switch might help. Stephan _______________________________________________ Maps-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/maps-l
