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 <finzelj@gmail.com>)
Ответы Re: idle_in_transaction_session_timeout for a set of SQL statements  (Jeremy Finzel <finzelj@gmail.com>)
Список pgsql-general
Дерево обсуждения
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
Дата:
Сообщение: Re: 9.0 standby - could not open file global/XXXXX
Следующее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: why not using a mountpoint as PGDATA?