X-Git-Url: https://git.8kb.co.uk/?p=postgresql%2Fpg_log_long_xact;a=blobdiff_plain;f=README.md;fp=README.md;h=7c7de6addddd5857e2c825180647b064eb1aba6d;hp=b5e9998c4242d2306ff7776d18bddfff66c37762;hb=799016a1d0213ab59c29c401c0e5345f4ac6c998;hpb=854b031fba63292ea22a9d653a4f2b844fe377a3 diff --git a/README.md b/README.md index b5e9998..7c7de6a 100755 --- a/README.md +++ b/README.md @@ -48,7 +48,7 @@ TEST=# SELECT public.pg_log_long_xact('1s', true, 'text'); To make it start cancelling statements exceeding a specific duration we pass a duration as the fourth argument; the first transaction exceeding this will be cancelled on each run, with blocking statements prioritised. - (As of pg 9.3 there's a lock_timeout parameter that will abort any statement waiting longer than the specified number of milliseconds, which is much better. Note that the difference here is that this function will attempt to abort the blocking statement rather than the waiting one.) + (As of pg 9.3 there's a lock_timeout parameter that will abort any statement waiting longer than the specified number of milliseconds, which is much better. Note that the difference here is that this function will attempt to abort the blocking transaction rather than the waiting statement, or if there is no locking just the longest transaction.) ```sql TEST=# SELECT public.pg_log_long_xact('1s', true, 'text', '10 minutes');