Re: idle_in_transaction_session_timeout for a set of SQL statements
От
Michael Lewis
Тема
Re: idle_in_transaction_session_timeout for a set of SQL statements
Дата
Msg-id
CAHOFxGoTc0V4CdqSJdb3+pVUeS=nETZrpzFi02SDV4rFHNvOUw@mail.gmail.com
Ответ на
idle_in_transaction_session_timeout for a set of SQL statements (Jeremy Finzel)
Список
Дерево обсуждения
idle_in_transaction_session_timeout for a set of SQL statements Jeremy Finzel <finzelj@gmail.com>
Re: idle_in_transaction_session_timeout for a set of SQL statements Michael Lewis <mlewis@entrata.com>
Re: idle_in_transaction_session_timeout for a set of SQL statements Jeremy Finzel <finzelj@gmail.com>
On Wed, Feb 27, 2019 at 7:56 AM Jeremy Finzel <finzelj@gmail.com> 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.
I don't think you are actually going idle. Check pg_stat_activity for what this transaction is doing. It should show waiting on locks, but not idle. I think the command you seek is
SET lock_timeout TO '1s';
В списке pgsql-general по дате отправления
От: Filip Rembiałkowski
Дата:
