[Tile-serving] [openstreetmap/osm2pgsql] possible optimization, dynamic increase of work_mem (#1419)

[Stephan]

I imported a smaller extract using osm2pgsql v1.4.1 resulting in a database size of 22GB. I noticed that PostgreSQL 13 used in total a few gigabytes of temp-files. I did a reset of the statistics and rendered tiles and I am quite certain that the temporary filed did not result from rendering. So I guess it is from the import.
I have configured `work_mem=1G` which seems to be too small in this case.

Could it bring some benefit on import speed if osm2pgsql would increase work_mem during the import session?
Has someone considered this already or would it require some test runs?

I queried the temp size with:

    SELECT temp_files AS "Temporary files", temp_bytes AS "Size of temporary files" FROM   pg_stat_database db;



-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/1419
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20210215/7af274a7/attachment.htm>