Tomcat - PostgreSQL - Perfomance Tunning

From: Germán Gazzoni <german(dot)gazzoni(at)ayi-asociados(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Tomcat - PostgreSQL - Perfomance Tunning
Date: 2003-09-27 18:04:53
Message-ID: !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAAFt6dcg6mhkaZEiw4QpiyC8KAAAAQAAAAm7Om86q3B0iBCOUrhzmcqgEAAAAA@ayi-asociados.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Germán Gazzoni 2003-09-27 18:23:57 Tomcat - PostgreSQL - Perfomance Tuning
Previous Message Tom Lane 2003-09-27 17:33:16 Re: initdb failure (was Re: [GENERAL] sequence's plpgsql)