Re: [PERFORM] PostgreSQL and sql-bench

Hi I am not comparing Postgres to MyISAM (obviously it is not a very fair comparison) and we do need ACID, so all comparison are made against InnoDB (which now supports MVCC as well). I will try again with the suggestions posted here. Thanks. --- Tom Lane <[EMAIL PROTECTED]> wrote:

[PERFORM] PostgreSQL and sql-bench

Hi After upgrading DBI and DBD::Pg, this benchmark still picks MySQL as the winner (at least on Linux RH3 on a Dell 1875 server with 2 hyperthreaded 3.6GHz CPUs and 4GB RAM). I've applied the following parameters to postgres.conf: max_connections = 500 shared_buffers = 3000 work_mem = 10 eff

Re: [PERFORM] sql-bench

You can use the test with InnoDB by giving the --create-options=engine=innodb option in the command line. Even with InnoDB, in some specific tests PG looks very bad compared to InnoDB. --- Tom Lane <[EMAIL PROTECTED]> wrote: > yoav x <[EMAIL PROTECTED]> writes: > >

Re: [PERFORM] sql-bench

So why are these queries so slow in PG? --- Dave Cramer <[EMAIL PROTECTED]> wrote: > All of the tuning parameters would affect all queries > > shared buffers, wal buffers, effective cache, to name a few > > --dc-- > On 13-Sep-06, at 8:24 AM, yoav x wrote: > > &

[PERFORM] sql-bench

Hi I am trying to run sql-bench against PostgreSQL 8.1.4 on Linux. Some of the insert tests seems to be ver slow For example: select_join_in Are there any tuning parameters that can be changed to speed these queries? Or are these queries especially tuned to show MySQL's stgrenths?