| From: | yoav x <yoav112003(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | PostgreSQL and sql-bench |
| Date: | 2006-09-21 14:52:44 |
| Message-ID: | 20060921145244.13005.qmail@web35813.mail.mud.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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?
Thanks.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brad Nicholson | 2006-09-21 15:03:12 | Re: PostgreSQL and sql-bench |
| Previous Message | Markus Schaber | 2006-09-21 07:31:12 | Re: Large tables (was: RAID 0 not as fast as |