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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match