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: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Jignesh K. Shah wrote:
> Hello all,
> I think this result will be useful for performance discussions of 
> postgresql against other databases.
> More on Josh Berkus's blog:

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

In response to


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-2017 The PostgreSQL Global Development Group