[Qgis-user] Offline background map for large regions

[abru345 at gmx.de]

Hi Asim,

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. Using an SSD for swap may
be possible, but would increase processing time dramatically because
it's extremely slow compared to RAM.

My system can handle no more than 16 GB and currently I have 8 GB, so
processing a 20 GB file is not an option for me. But maybe I can split
up and import the countries separately.

Regards

Andreas




Am 15.07.22 um 07:27 schrieb Asim:
>
> On 7/15/22 5:05 AM, Andreas via Qgis-user wrote:
>> Postgres may not work for me, as I read it needs at least as much RAM as
>> the file size to import the map into the database. My vector tiles have
>> 20 GB while my PC only 8 GB. It may run out of memory.
>
>
> Not intending to diverge from the main topic of this thread but just out
> of curiosity, can you please share some pointers where this limitation
> of PostgreSQL is discussed?  My impression of PostgreSQL is it remains
> functional with fairly ancient hardware and limited resources.
>
> By the way, thank you Andreas for starting this thread, I'm learning a
> lot from the discussions.
>
> Asim
>
>
>