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

Re: PostgreSQL publishes first real benchmark

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: "Jignesh K(dot) Shah" <J(dot)K(dot)Shah(at)Sun(dot)COM>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL publishes first real benchmark
Date: 2007-07-11 15:59:32
Message-ID: 4694FE64.8070407@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2007-07-11 16:10:55
Subject: Re: TIMING A QUERY ???
Previous:From: Bryan MurphyDate: 2007-07-11 15:51:51
Subject: Re: Two questions.. shared_buffers and long reader issue

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