Skip site navigation (1) Skip section navigation (2)

Re: Autovacuum running out of memory

From: Mark Lewis <mark(dot)lewis(at)mir3(dot)com>
To: Jason Lustig <lustig(at)brandeis(dot)edu>
Cc: Richard Huxton <dev(at)archonet(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Autovacuum running out of memory
Date: 2007-10-16 14:33:15
Message-ID: 1192545195.6447.54.camel@archimedes (view raw or flat)
Thread:
Lists: pgsql-performance
On Tue, 2007-10-16 at 10:14 -0400, Jason Lustig wrote:
> I ran "ulimit -a" for the postgres user, and here's what I got:
...
> max memory size         (kbytes, -m) 200000
> open files                      (-n) 100
> max user processes              (-u) 100
> virtual memory          (kbytes, -v) 200000
...

These settings are all quite low for a dedicated database server, they
would be more appropriate for a small development instance of PG sharing
a machine with several other processes.

Others have commented on the memory settings, but depending on the
maximum number of connections you expect to have open at any time you
may want to consider increasing the max user processes and open files
settings as well.

-- Mark Lewis

In response to

pgsql-performance by date

Next:From: Jason LustigDate: 2007-10-16 14:54:12
Subject: Re: Autovacuum running out of memory
Previous:From: Tom LaneDate: 2007-10-16 14:26:08
Subject: Re: Vacuum goes worse

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group