Hi Patrick,
sounds worth to have a look at, thank you!
About the 180 GB database - is it normal that putting osm data into
spatialite inflates the volume by factor 6?
Did a simple
ogr2ogr -f "SQLite" -dsco SPATIALITE=YES name_of_new_file.db
name_of_extracted_file.pbf
or makes it sense to fine
What are you drawing that needs 180 GB of data? That's the whole
question. That's a lot of data for vectors.
In other words going back to my previous point - you do not need to draw
all of the detail at lower scales. Use scaling rules to address that and
performance should show a big increase.