On 11/7/14, 1:19 PM, Michael Banck wrote:
Am Montag, den 27.10.2014, 19:29 +0000 schrieb Thom Brown:
>On 27 October 2014 19:21, Josh Berkus<j...@agliodbs.com> wrote:
> >I just realized that there is one thing we can't log currently:
> >transactions which last more than #ms. This is valuable diagnostic
> >information when looking for issues like causes of bloat and deadlocks.
> >
> >I'd like it to be on the TODO list because it seems like part of a good
> >GSOC project or first-time contribution.
>
>
>So effectively, log_min_duration_transaction? Sounds useful.
FWIW, I've also wanted the equivalent of statement_timeout for transactions;
the ability to abort a transaction if it runs for too long.
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
