[OSM-dev] vacuum running amok - and me too ;)

[Walter Nordmann]

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.