> 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.
In response to
pgsql-performance by date
|Next:||From: Guido Neitzer||Date: 2006-05-18 11:02:29|
|Subject: Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle|
|Previous:||From: Gregory S. Williamson||Date: 2006-05-18 10:55:32|
|Subject: Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2|