[Tile-serving] [osm2pgsql-dev/osm2pgsql] Daylight Ingest and Slow Deletions (Discussion #2088)

[pyoung-sc]

Looks like the settings it used (RDS defaults I presume...) were
```
            name             | setting | boot_val | reset_val | unit
------------------------------+---------+----------+-----------+------
 autovacuum_work_mem          | 4055788 | -1       | 4055788   | kB
 checkpoint_completion_target | 0.9     | 0.9      | 0.9       |
 checkpoint_timeout           | 300     | 300      | 300       | s
 maintenance_work_mem         | 2127626 | 65536    | 2127626   | kB
 max_wal_senders              | 0       | 10       | 0         |
 max_wal_size                 | 2048    | 1024     | 2048      | MB
 random_page_cost             | 4       | 4        | 4         |
 shared_buffers               | 4055788 | 16384    | 4055788   | 8kB
 wal_level                    | minimal | replica  | minimal   |
 work_mem                     | 4096    | 4096     | 4096      | kB
 ```
 I'll give it another go with what's mentioned in the manual (work_mem looks especially small!).

-- 
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2088#discussioncomment-7372799
You are receiving this because you are subscribed to this thread.

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/2088/comments/7372799 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20231024/d2eddca7/attachment.htm>