Hello Andres,
Do you have both, longrunning transactions and transactions with many
> subtransactions?
>
> Yes long running plane SQL queries as well as many short SQL queries
running one after another in one long spanning transaction (we are working
on eliminating this kind of behavior, but it is some of the analysis tools
opening a transaction and then fetching lots of data with small queries).
Also many relatively short running calls (up to 500ms) to quite complicated
read-only stored procedures is being done constantly on that machine.
Regards,
-- Valentine