Re: Autovacuum running out of memory

[Richard Huxton <dev(at)archonet(dot)com>]

Jason Lustig wrote:
> I ran "ulimit -a" for the postgres user, and here's what I got:

> max memory size         (kbytes, -m) 200000
> virtual memory          (kbytes, -v) 200000

There you go - you probably are exceeding these.

Add some lines to /etc/security/limits.conf to increase them.

--
  Richard Huxton
  Archonet Ltd