Skip site navigation (1) Skip section navigation (2)

Re: Tomcat - PostgreSQL - Perfomance Tuning

From: "" <sarathi(at)excite(dot)com>
To: nickf(at)ontko(dot)com, gazzoni(at)hotmail(dot)com, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Tomcat - PostgreSQL - Perfomance Tuning
Date: 2003-09-28 14:14:53
Message-ID: 20030928141453.24ACFB6C7@xmxpita.excite.com (view raw or flat)
Thread:
Lists: pgsql-jdbc

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!

pgsql-jdbc by date

Next:From: Paul ThomasDate: 2003-09-29 07:53:03
Subject: Re: Tomcat - PostgreSQL - Cannot load JDBC driver class "null"
Previous:From: b-volDate: 2003-09-28 12:03:55
Subject: Re: problems installing 7.3.4 with java

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group