Hi, running postgresql on ubuntu for many years, but now i'm in big trouble.
My system has 24GB of real memory but after some hours one autovacuum worker is using 80-90% of memory, the OOM-Killer (out of memory killer) kills the process with kill -9 and the postgresql-server is restarting because of that problem. i changed the base configuration to use very small buffers, restartetd the server twice but the problem still exists. i think, it's allways the same table and that table is huge: 111GB data and 3 Indices with 4GB, 128 GB and 12 GB. It's the table planet_osm_ways from openstreetmap. maybe that helps. without running server 8GB are user by other programs and 16GB are free. no idea whats going on. regards walter -- View this message in context: http://postgresql.nabble.com/autovacuum-worker-running-amok-and-me-too-tp5840299.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
