[Qgis-user] Offline background map for large regions
abru345 at gmx.de
abru345 at gmx.de
Wed Jul 20 13:42:53 PDT 2022
Hi Asim,
meanwhile I found out that creating a spatialite database needs (unlike
postgres) only very little RAM for building. On the other side, after
running a wole day and night on conversion of the ~30GB osm_europe.pbf
with ogr2ogr, I have a 180 GB database now which needs minutes to load...
Don't know if postgres is more performant. Setup is much more complicated.
Regards,
Andreas
Am 20.07.22 um 03:43 schrieb Asim:
>
> On 7/15/22 4:11 PM, Andreas via Qgis-user wrote:
>> I think postgres itself is not the problem at all, but the scripts that
>> move the vector tiles into the database. In the instructions for usage
>> of these import scripts is written that they need at least as much RAM
>> as the size of the vector file. So I assume it has to load the whole
>> file into memory before it can be processed.
>
> Thank you for the clarification, Andreas. I'm new to the GIS ecosystem
> but the OGR FDW seems to be addressing the problem of not having to load
> entire vector data at once: https://github.com/pramsey/pgsql-ogr-fdw.
>
> Asim
>
More information about the Qgis-user
mailing list