The performance issue you are seeing may be more linux related manifesting on the database performance. Use a tool like
iperfto test the operating system with many client connections should give you a better idea. As suggested connection
poolingwill help in such a case.
Regards,
SI.
--- On Sat 09/27, Nick Fankhauser < nickf@ontko.com > wrote:
From: Nick Fankhauser [mailto: nickf@ontko.com]
To: gazzoni@hotmail.com, pgsql-jdbc@postgresql.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@postgresql.org<br>>
[mailto:pgsql-jdbc-owner@postgresql.org]OnBehalf Of Germ�n Gazzoni<br>> Sent: Saturday, September 27, 2003 1:24 PM<br>>
To:pgsql-jdbc@postgresql.org<br>> Subject: [JDBC] Tomcat - PostgreSQL - Perfomance Tuning<br>> Importance:
High<br>><br>><br>><br>>We�re using PostgresSQL with Tomcat on Linux Red Hat 9 kernel 2.4.20-8<br>> and we�re
experiencingperformance problems when more than 20 users are<br>> connected to the database..<br>><br>> The database
hasapproximately 24 MB, the application is entirely<br>> constructed with Java an all of connections on that database
areusing<br>> JDBC.<br>><br>> The server characteristics are:<br>> - Pentium 4 2.8 Mhz<br>> - 2 GB of RAM<br>> - 80 GB
ofdisk 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>> Germ�n<br>><br>> ---------------------------(end of
broadcast)---------------------------<br>>TIP 7: don't forget to increase your free space map
settings<br>><br>><br><br><br><br>---------------------------(endof broadcast)---------------------------<br>TIP 1:
subscribeand unsubscribe commands go to majordomo@postgresql.org<br>
_______________________________________________
Join Excite! - http://www.excite.com
The most personalized portal on the Web!
