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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jason Lustig | 2007-10-16 14:54:12 | Re: Autovacuum running out of memory |
Previous Message | Tom Lane | 2007-10-16 14:26:08 | Re: Vacuum goes worse |