| From: | Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info> |
|---|---|
| To: | yoav x <yoav112003(at)yahoo(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL and sql-bench |
| Date: | 2006-09-21 15:03:12 |
| Message-ID: | 1158850992.30235.10.camel@dba5.int.libertyrms.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Thu, 2006-09-21 at 07:52 -0700, yoav x wrote:
> 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 = 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
towards MySQL.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Lewis | 2006-09-21 15:05:18 | Re: PostgreSQL and sql-bench |
| Previous Message | yoav x | 2006-09-21 14:52:44 | PostgreSQL and sql-bench |