Thread: Tomcat - PostgreSQL - Perfomance Tuning
Were using PostgresSQL with Tomcat on Linux Red Hat 9 kernel 2.4.20-8 and we´re experiencing performance problems when more than 20 users are connected to the database.. The database has approximately 24 MB, the application is entirely constructed with Java an all of connections on that database are using JDBC. The server characteristics are: - Pentium 4 2.8 Mhz - 2 GB of RAM - 80 GB of disk storage Any body can help us on how to begin a performance tuning job for this architecture?. Thanks, Germán
Are you using connection pooling? If not, that would be a good place to start on the application side. -Nick > -----Original Message----- > From: pgsql-jdbc-owner@postgresql.org > [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Germán Gazzoni > Sent: Saturday, September 27, 2003 1:24 PM > To: pgsql-jdbc@postgresql.org > Subject: [JDBC] Tomcat - PostgreSQL - Perfomance Tuning > Importance: High > > > > Were using PostgresSQL with Tomcat on Linux Red Hat 9 kernel 2.4.20-8 > and we´re experiencing performance problems when more than 20 users are > connected to the database.. > > The database has approximately 24 MB, the application is entirely > constructed with Java an all of connections on that database are using > JDBC. > > The server characteristics are: > - Pentium 4 2.8 Mhz > - 2 GB of RAM > - 80 GB of disk storage > > > Any body can help us on how to begin a performance tuning job for this > architecture?. > > Thanks, > > Germán > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings > >
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!
Germán, You might also what to try the pgsql-performance mail list. --Barry Germán Gazzoni wrote: > We’re using PostgresSQL with Tomcat on Linux Red Hat 9 kernel 2.4.20-8 > and we´re experiencing performance problems when more than 20 users are > connected to the database.. > > The database has approximately 24 MB, the application is entirely > constructed with Java an all of connections on that database are using > JDBC. > > The server characteristics are: > - Pentium 4 2.8 Mhz > - 2 GB of RAM > - 80 GB of disk storage > > > Any body can help us on how to begin a performance tuning job for this > architecture?. > > Thanks, > > Germán > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings >