Re: Tomcat - PostgreSQL - Perfomance Tuning

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
>
>
>
> 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
>
>