Re: idle_in_transaction_session_timeout for a set of SQL statements

2019-02-27 Thread Jeremy Finzel
> > SET lock_timeout TO '1s'; > No, my assumption is that lock_timeout does not cover my use case here. My point is actually that any one statement is not hitting lock_timeout, but as a whole the transaction takes too long. For example if I set lock_timeout to 1 second, but my migration actually

Re: idle_in_transaction_session_timeout for a set of SQL statements

2019-02-27 Thread Michael Lewis
On Wed, Feb 27, 2019 at 7:56 AM Jeremy Finzel wrote: > I was hoping to use idle_in_transaction_session_timeout to prevent schema > change migrations from running too long and thereby locking up the > application for an extended period even if any one statement in the > migration is very short. >