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