On Thu, 2006-09-21 at 07:52 -0700, yoav x wrote:
> 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 = 100000
> effective_cache_size = 3000000000
> Most queries still perform slower than with MySQL.
> Is there anything else that can be tweaked or is this a limitation of PG or the benchmark?
As mentioned by others, you are using a benchmark that is slanted
In response to
pgsql-performance by date
|Next:||From: Mark Lewis||Date: 2006-09-21 15:05:18|
|Subject: Re: PostgreSQL and sql-bench|
|Previous:||From: yoav x||Date: 2006-09-21 14:52:44|
|Subject: PostgreSQL and sql-bench|