mboeringa

> I've reindexed my planet database right after an initial import. > > The size benefit is clear, almost 1/3 of GIST index (except for planet_osm_point). > The spped benefit...

> There is a small 10% impact on a single query but of course all the data is in the cache and possible benefit of have more index/data in the...

> I've previously thought that there would be a lot of moderation work (e.g. deleting spam diary entries) that don't need to have any DWG involvement at all. @gravitystorm ,...

> It's not uncommon for people to post diaries without editing though so I don't really want to just ban it. Even if that is the case, requiring them to...

> * The `--cache/-C` setting has been ignored in non-slim mode for a while. @joto, does this remark mean the cache setting is truly _completely ignored_ when running in **non-slim**...

Well, probably not directly relevant to the project and the new generalization options of osm2pgsql, but via the JTS GitHub repository, I stumbled on this project: https://github.com/micycle1/PGS#morphology If not for...

Just for the record: With current PG16 and Facebook Daylights v1.33 **1.1B** records building dataset, CLUSTER using the geometry spatial index as input is incredibly slow (majority of time spend...

In one instance I fixed quite some time ago, I encountered almost a dozen similar MP relations in one location, where each subsequent MP had one or a few inners...

> One outer-inner MP for every inner... > > Fixing this I downloaded an area along the other way and found there was even one more MP with 17 inner...

> The problem is I think that people want to add an "inner" to an "outer" but doing so they are not aware that the "outer" had already a relation....