[OSM-dev] Brin index on contour lines DB

[Yves]

Hello,
I'm reworking the DEM at Opensnowmap.org taking advantage of modern lidar data while keeping a ~30m resolution. 

I'm planning to experiment on optimizing the world-wide contour line DB. It's currently 504GB of dead data just for rendering, and quite expensive in term of storage. 
The current Gist index takes 54GB on disk, so I guess I could save this with a Brin index instead. After all contours requests to the DB starts at zoom 11, so they are always big chunks in the order of 0.1x0.1° max.
Anyone has already experience in this? 


The other drastic measure I envision is to limit the data to places with ski pistes, but that limit the usefulness of the data : my last extract from 2015 was shared widely to a number of projects. 

Other optimisation suggestions welcome. 

Regards, 
Yves 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20230429/fb14e00b/attachment.htm>