Hi, tried to get help on the postgresql-general forum but they didn't help me yet. (http://postgresql.nabble.com/autovacuum-worker-running-amok-and-me-too-td5840299.html)
*Vacuum planet_osm_ways* is using very, very much memory vacuuming the GIN-Index planet_osm_ways_nodes. Running on a 24GB-System with now 50GB Swap i had to kill the Vacuum after using about 68 GB Virt memory (> 80% total) because of thrashing. the postgresql-config-params are very conservative, because i reduced them to minimize mem usage: <http://gis.19327.n5.nabble.com/file/n5836373/pidstat.png> A graph on memory usage during vaccuuming until i had to reboot my system. left scale virt mem in MB. Any hints? Feeling helpless. Regards walter ----- [url=http://osm.wno-edv-service.de/residentials] Missing Residentials Map 1.17[/url] [url=http://osm.wno-edv-service.de/plz] Postcode Map 2.0.2[/url] -- View this message in context: http://gis.19327.n5.nabble.com/vacuum-running-amok-and-me-too-tp5836373.html Sent from the Developer Discussion mailing list archive at Nabble.com. _______________________________________________ dev mailing list [email protected] https://lists.openstreetmap.org/listinfo/dev
