Tomcat - PostgreSQL - Perfomance Tuning

From: Germán Gazzoni <gazzoni(at)hotmail(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Tomcat - PostgreSQL - Perfomance Tuning
Date: 2003-09-27 18:23:57
Message-ID: !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAAFt6dcg6mhkaZEiw4QpiyC8KAAAAQAAAAEpfk+zlf/0O1J4m2gAHDwAEAAAAA@hotmail.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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Bruce Momjian 2003-09-27 20:14:08 Re: Statement.cancel() may cancel queries in the future
Previous Message Germán Gazzoni 2003-09-27 18:04:53 Tomcat - PostgreSQL - Perfomance Tunning