On 8 Apr 2002 at 10:23, Shanmugasundaram Doraisamy wrote: > Thank your for your replies. As guessed by S.R.S. > we are using Java applications as the front end and Postgres as the > backend. But to the extent I know we close the connection once the data > lookup is over. Probably there might be a couple of places where we have > not done so.
I would say don't use java if you are serious about performance. Are you running it on same machine? > I have also noticed one other things in our system, i.e. the Java > application or their threads do not get closed when the application is > closed. How do I do that. Please suggest. I had tried a couple of Java > user groups but didn't get a good reply. And did you check what happens to connections opened by them? When you start postmaster, start verbose logging and see the usage pattern. Run a stress test just to see what happens. if it doesn't terminates the clients, you need to check out the code(I mean that's not very unobvious solution but point is with this kind of behaviour, system will not scale for and RDBMS and any hardware configuration..) I will check out if you can kick out connections on some criterias. Brute force but may work.. > CPU - Celeron 866 Mhz > RAM - 512 MB > HDD - 20 GB IDE > OS - Redhat 7.1 Ditch celeron. no good for any serious work. Get a P-III..These days it should be a cheap swap.. HTH Shridhar _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help
