[Tile-serving] [openstreetmap/mod_tile] renderd throws reason: Postgis Plugin: bad connection error when rendering with render_list (Issue #467)

[a14stoner]

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/2412910410 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20241014/f5870f34/attachment.htm>