hello, thank you for your suggestion. I applied them to my .mml file and it
seems this fixes the problem. wow... 🥳🥳🥳🥳
I use PostgresSQL Version 15.2 with some optimized configurations from pgtune:
```
# DB Version: 15
# OS Type: linux
# DB Type: dw
# Total Memory (RAM): 94 GB
# CPUs num: 20
# Connections num: 1000
# Data Storage: hdd
max_connections = 1000
shared_buffers = 24064MB
effective_cache_size = 72192MB
maintenance_work_mem = 2GB
checkpoint_completion_target = 0.9
wal_buffers = 16MB
default_statistics_target = 500
random_page_cost = 4
effective_io_concurrency = 2
work_mem = 1232kB
huge_pages = try
min_wal_size = 4GB
max_wal_size = 16GB
max_worker_processes = 20
max_parallel_workers_per_gather = 10
max_parallel_workers = 20
max_parallel_maintenance_workers = 4
autovacuum_work_mem = 4GB
wal_level = minimal
checkpoint_timeout = 60min
max_wal_senders = 0
full_page_writes=off
fsync=off
jit=off
```
the last 7 parameters i found in different forum posts .. they seem to fasten
the render process.
do you recommend any other config change on my postgresql.conf?
i started up rendering from Z17 to Z18 - lets see how it goes. Anyway, i will
report back in the coming days if the config change was 100% sucessful.
--
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/mod_tile/issues/467#issuecomment-2412910410
You are receiving this because you are subscribed to this thread.
Message ID: <openstreetmap/mod_tile/issues/467/[email protected]>
_______________________________________________
Tile-serving mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/tile-serving
