On 16 Jan 2002 at 12:04, Ramanujam Muralidharan wrote: > > hi , > The apache-tomcat server that is present in our clients place >is very unstable and goes down very often inspite of having 1 gb of RAM . We >are using postgres as the backend . does Postgres ( single threaded db ) have >an effect on apache-tomcat . will the perdormance improve if i switch to a ?multithreaded db ? or do i need to change the config files .
I don't think it's problem with postgres but rather it may be some issue with tuning of system.. 1)Try adding more buffers with -B option. man postmaster for more details. 2)Make maximum number of postgres children more than max. apache processes. 3)Increase max. possible shared memory segment to something like 256MB. The default is quite low and postgres hogs CPU if not enough shard memory is made available. On my mandrake system with devfs, max. shm is half the total memory which I would say very optimal setting.. Frankly all of these are shots in dark. Go thr. logs of apache/tomcat and postgres to check the exact reason. If you experience high CPU load before crash then it's postgres most probably. Pump up max. shared memory accordingly. It's documented in postgres docs. And I don't believe postgres being single threaded as any issue. How much overhead difference is there between a thread and a process in linux? It's very small. Only drawback of not being multithreaded is system can not spread work of a single client across CPUs because of process affinity. Postgres team is working to handle this situation... HTH Shridhar _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help
