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