"Olivier Andreotti" <[EMAIL PROTECTED]> writes:
> Just a last question about the pg_xlog : i understand that the
> directory must be moved but i have just 3 disks for the database :
> disk 1 and 2 for the data, disk 3 for the indexes, where can i put the
> pg_xlog ?
If you have three disks then pu
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
"Mikael Carneholm" <[EMAIL PROTECTED]> writes:
> Btw, check you logfile for hints regarding increasing max_fsm_pages, and
> consider increasing checkpoint_segments as well. You could also play
> with more aggressive bgwriter_* params to reduce the risk for long
> vacuum pauses.
Yeah, checkpoint_se
mance@postgresql.org
Subject: [PERFORM] Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle
10g2
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
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
To: pgsql-performance@postgresql.org
Cc:
Subject: [PERFORM] Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle
10g2
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
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
