Germán,
You might also what to try the pgsql-performance mail list.
--Barry
Germán Gazzoni wrote:
> 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
>