Re: Autovacuum running out of memory - Mailing list pgsql-performance

From Mark Lewis
Subject Re: Autovacuum running out of memory
Date
Msg-id 1192545195.6447.54.camel@archimedes
Whole thread Raw
In response to Re: Autovacuum running out of memory  (Jason Lustig <lustig@brandeis.edu>)
List 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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Vacuum goes worse
Next
From: Jason Lustig
Date:
Subject: Re: Autovacuum running out of memory