Re: Tomcat - PostgreSQL - Perfomance Tuning

The performance issue you are seeing may be more linux related manifesting on the database performance. Use a tool like iperf to test the operating system with many client connections should give you a better idea. As suggested connection pooling will help in such a case.

Regards,
SI.

--- On Sat 09/27, Nick Fankhauser < nickf(at)ontko(dot)com > wrote:
From: Nick Fankhauser [mailto: nickf(at)ontko(dot)com]
To: gazzoni(at)hotmail(dot)com, pgsql-jdbc(at)postgresql(dot)org
Date: Sat, 27 Sep 2003 16:40:22 -0500
Subject: Re: [JDBC] Tomcat - PostgreSQL - Perfomance Tuning

<br>Are you using connection pooling? If not, that would be a good place to<br>start on the application side.<br><br>-Nick<br><br>> -----Original Message-----<br>> From: pgsql-jdbc-owner(at)postgresql(dot)org<br>> [mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Germn Gazzoni<br>> Sent: Saturday, September 27, 2003 1:24 PM<br>> To: pgsql-jdbc(at)postgresql(dot)org<br>> Subject: [JDBC] Tomcat - PostgreSQL - Perfomance Tuning<br>> Importance: High<br>><br>><br>><br>> Were using PostgresSQL with Tomcat on Linux Red Hat 9 kernel 2.4.20-8<br>> and were experiencing performance problems when more than 20 users are<br>> connected to the database..<br>><br>> The database has approximately 24 MB, the application is entirely<br>> constructed with Java an all of connections on that database are using<br>> JDBC.<br>><br>> The server characteristics are:<br>> - Pentium 4 2.8 Mhz<br>> - 2 GB of RAM<br>> - 80 GB of disk storage<br>><br>><br>> Any body can help us on how to begin a performance tuni
ng job for this<br>> architecture?.<br>><br>> Thanks,<br>><br>> Germn<br>><br>> ---------------------------(end of broadcast)---------------------------<br>> TIP 7: don't forget to increase your free space map settings<br>><br>><br><br><br><br>---------------------------(end of broadcast)---------------------------<br>TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org<br>

_______________________________________________
Join Excite! - http://www.excite.com
The most personalized portal on the Web!