From: Jeff Davis <pgsql@j-davis.com>
To: yoav x <yoav112003@yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL and sql-bench
Date: Thu, 21 Sep 2006 09:45:56 -0700
Message-ID: <1158857156.30652.197.camel@dogma.v10.wvs> (raw)
In-Reply-To: <20060921145244.13005.qmail@web35813.mail.mud.yahoo.com>
References: <20060921145244.13005.qmail@web35813.mail.mud.yahoo.com>
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
That's a low setting. 3000*8192 = 24MB. This should probably be closer
to 25% total memory, or 1GB, or 131072 shared buffers (however, that's
just a rule of thumb, there may be a better setting).
> work_mem = 100000
> effective_cache_size = 3000000000
That is a very high setting. effective_cache_size is measured in disk
pages, so if you want 3GB the correct setting is 393216.
>
> 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 others have pointed out, sql-bench may not be a realistic benchmark.
The best way to examine performance is against real work.
Also, consider that relational databases were not developed to increase
performance. Things like filesystems are inherently "faster" because
they do less. However, relational databases make development of systems
of many applications easier to develop, and also make it easier to make
a well-performing application. If the benchmark isn't testing anything
that a filesystem can't do, then either:
(a) Your application could probably make better use of a relational
database; or
(b) The benchmark doesn't represent your application's needs.
Regards,
Jeff Davis
Regards,
Jeff Davis
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pgsql@j-davis.com, yoav112003@yahoo.com
Subject: Re: PostgreSQL and sql-bench
In-Reply-To: <1158857156.30652.197.camel@dogma.v10.wvs>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox