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