Am 10.11.2010 09:23, schrieb Thomas Ineichen:
Are there any plans for optimising? Perhaps some
indexes on often used
tags in hstore? Or another rendering strategy (like Kay suggested
[i.e. always use 10% for 'background'])?
There is already an index on
hstore, it may help to put indexes on the
regular columns that are used by the osm style, but in the problematic
zone (z11-z12) only the geom index is used.
We changed the expire process to expire z12 only once a week -- not on
every change. This should stabilize the queue and let the server catch
up ad night. It may take one or two days until we see results of this.
After that, I'll update the two changed styles.
Peter