Hello everybody !
Thanks for all the advices, iI will try all theses new values, and
i'll post my final values on this thread.
About the benchmark and the results, i dont know if can publish values
about Oracle performance ? For MySQL and PostgreSQL, i think there is
no problems.
Just a last qu
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.
> share
2006/5/18, Chris Mair <[EMAIL PROTECTED]>:
Hello :)
Hello Chris
What version would PostgreSQL 8.1.4 be?
Hum, ok, it is the 8.1.3 version :)
Could you give us some more infos about the box' performance while you
run the PG benchmark? A few minutes output of "vmstat 10" maybe? What
does "
Hello,
I'm running a benchmark with theses 3 databases, and the first results
are not very good for PostgreSQL.
PostgreSQL is 20% less performance than MySQL (InnoDB tables)
My benchmark uses the same server for theses 3 databases :
Dell Power edge - Xeon 2.8 Ghz - 2 Go Ram - 3 SCSI disks - Deb
