[Maps-l] Simpler psql statement

[Stephan Knauss]

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