[BUG] Processing gaps crashes when a country contains too many tiles
The process_gaps_in_exposure
function crashes due to very high memory usage for countries with many tiles. While Sweden with about 100 million tiles was processed, Norway with its 230 million tiles could not be processed. While looking into improving the query, we think that splitting the query into two to avoid the CROSS JOIN
is a promising avenue to make it run.