On 16/01/02 12:04 -0000, 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 .A Whats in the logs? 1GB of RAM is good, but what about the disk? Do you ever reach swap? I sugest putting postgres on its own dedicated system with *fast* disks and oodles of RAM. Tune your postgres install as well. Make sure your Java servlets clean up their threads. GC is not a very good idea under high load. Reuse objects if you can. Use Tomcat 4.0, with postgres 7.1.x. How does your system go down? What errors do you get? Show CPU loads, vmstat output and logs (you do have those, right?) when the Tomcat goes down. Postgres can be tuned for avery high performance, its defaults are very conservative. Make sure you catch exceptions, recover from them. Don't kill threads off when an exception like "cannot connect to database" occurs. I suggest holding off and throttling down your application in that case.
If you need more connections than 1024, you will have yto reompile your postgres database (This is a hardcoded define). Devdas Bhagat _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help
