DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender;
	b=HgvgIU3q6wqLvpWink3CYPiuPQok5SHOfWl2hLhaVFUK+lLKzPWuofaoBvUl+jOE/0ggWVLMAMjRMCIsjiGsrlZ0WGEA0z+Enz+ItDhRZ74G6dnsyrdYsk+NAmz3VncKfWPKrKyB0OYji30cM+S15kv4Q0H1HvYtsmZk67wkP0U=
Message-ID: <4694FE64.8070407@enterprisedb.com>
Date: Wed, 11 Jul 2007 16:59:32 +0100
From: Heikki Linnakangas <heikki@enterprisedb.com>
User-Agent: Icedove 1.5.0.10 (X11/20070329)
MIME-Version: 1.0
To: "Jignesh K. Shah" <J.K.Shah@Sun.COM>
CC: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL publishes first real benchmark
References: <46925AD9.9020208@sun.com>
In-Reply-To: <46925AD9.9020208@sun.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Jignesh K. Shah wrote:
> Hello all,
> 
> I think this result will be useful for performance discussions of 
> postgresql against other databases.
> 
> http://www.spec.org/jAppServer2004/results/res2007q3/
> 
> More on Josh Berkus's blog:
> 
> http://blogs.ittoolbox.com/database/soup/archives/postgresql-publishes-first-real-benchmark-17470 


May I ask you why you set max_prepared_transactions to 450, while you're 
apparently not using prepared transactions, according to this quote:

> Recoverable 2-phase transactions were used to coordinate the interaction between
> the database server and JMS server using Sun's Last Agent Logging
> Optimization; the 1PC database transactions and transaction log records are
> written to the database in a single transaction.

Did you perhaps use 2PC at first, but didn't bother to change the config 
after switching to the last agent optimization?

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com