Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2

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