DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=1dKV3hPKP/sThisNkNjppOIBb1sUnPCU5If9H8IO8d3wmuUMFIvK5XgUnIuVVMyi1+/wOtRVa1RY+PHHw9mW8O3NqQYHNJgNcuAWt7xE7yinlfUgogX2CDoPBX7TmfSyxPgdMn/2CIKjXuI9K6e9wSMFZWFJiSU6PR+lDAchlCg=
	;
Message-ID: <20060925145817.74843.qmail@web35811.mail.mud.yahoo.com>
Date: Mon, 25 Sep 2006 07:58:17 -0700 (PDT)
From: yoav x <yoav112003@yahoo.com>
Subject: Re: PostgreSQL and sql-bench 
To: pgsql-performance@postgresql.org
In-Reply-To: <829.1158851565@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi

I am not comparing Postgres to MyISAM (obviously it is not a very fair comparison) and we do need
ACID, so all comparison are made against InnoDB (which now supports MVCC as well). I will try
again with the suggestions posted here.

Thanks.


--- Tom Lane <tgl@sss.pgh.pa.us> wrote:

> yoav x <yoav112003@yahoo.com> writes:
> > I've applied the following parameters to postgres.conf:
> 
> > max_connections = 500
> > shared_buffers = 3000
> > work_mem = 100000
> > effective_cache_size = 3000000000
> 
> Please see my earlier reply --- you ignored at least
> checkpoint_segments, which is critical, and perhaps other things.
> 
> Don't forget also that testing mysql/myisam against fsync = on
> is inherently unfair.
> 
> 			regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com