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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
