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