Re: Autovacuum running out of memory

From: Richard Huxton <dev(at)archonet(dot)com>
To: Jason Lustig <lustig(at)brandeis(dot)edu>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Autovacuum running out of memory
Date: 2007-10-16 14:22:35
Message-ID: 4714C92B.6010909@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2007-10-16 14:22:54 Re: Autovacuum running out of memory
Previous Message Jason Lustig 2007-10-16 14:14:30 Re: Autovacuum running out of memory