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?
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2007-07-11 16:10:55|
|Subject: Re: TIMING A QUERY ??? |
|Previous:||From: Bryan Murphy||Date: 2007-07-11 15:51:51|
|Subject: Re: Two questions.. shared_buffers and long reader issue|