Do you use prepared statements through JDBC with bound variables? If yes, you might have problems with PostgreSQL not choosing optimal plans because every statement is planned "generically" which may force PostgreSQL not to use indexes.
i used prepared statements for the 3 databases.
> shared_buffer = 16384 This may be higher.
I'll try that.
> autovaccuum = on And you are sure, it's running?
Yes, i can see autovaccum in the postgresql.log.
