Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL and sql-bench

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 (view raw or flat)
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. 


In response to

pgsql-performance by date

Next:From: Mark LewisDate: 2006-09-21 15:05:18
Subject: Re: PostgreSQL and sql-bench
Previous:From: yoav xDate: 2006-09-21 14:52:44
Subject: PostgreSQL and sql-bench

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group