Date: Wed, 11 Jul 2007 12:33:01 -0400
From: "Jignesh K. Shah" <J.K.Shah@Sun.COM>
Subject: Re: PostgreSQL publishes first real benchmark
In-reply-to: <4694FE64.8070407@enterprisedb.com>
To: Heikki Linnakangas <heikki@enterprisedb.com>
Cc: pgsql-performance@postgresql.org
Message-id: <4695063D.9040108@sun.com>
Organization: Sun Microsystems
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Content-transfer-encoding: 7BIT
References: <46925AD9.9020208@sun.com> <4694FE64.8070407@enterprisedb.com>
User-Agent: Thunderbird 1.5.0.8 (X11/20061110)


Heikki Linnakangas wrote:
>
>
> 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?
>

Yep.. one of the things that we didn't revert back and got strayed out 
there.

-Jignesh