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.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org

Reply via email to