" (sa...@excite.com)

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 < [email protected: n...@ontko.com] > wrote:
From: Nick Fankhauser [mailto: [email protected: n...@ontko.com]]
To: [email protected: ga...@hotmail.com], [email protected: pgsql...@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>> [email protected: pgsql-jdbc-...@postgresql.org]On Behalf 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 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>> 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>---------------------------(end of broadcast)---------------------------<br>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org<br>

Hi All,
I would like to know how to call a java method from sql trigger code or a function.

Thanks,
Sarathi.