Re: idle_in_transaction_timeout

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: idle_in_transaction_timeout
Дата
Msg-id 53A1EE47.5050600@agliodbs.com
обсуждение исходный текст
Ответ на idle_in_transaction_timeout  (Vik Fearing <vik.fearing@dalibo.com>)
Ответы Re: idle_in_transaction_timeout  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On 06/18/2014 12:32 PM, Tom Lane wrote:
> Josh Berkus <josh@agliodbs.com> writes:
>>  There are plenty of badly-written applications which "auto-begin", that
>> is, they issue a "BEGIN;" immediately after every "COMMIT;" whether or
>> not there's any additional work to do.  This is a major source of IIT
>> and the timeout should not ignore it.
> 
> Nonsense.  We explicitly don't do anything useful until the first actual
> command arrives, precisely to avoid that problem.

Oh, we don't allocate a snapshot?  If not, then no objection here.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: How about a proper TEMPORARY TABLESPACE?
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Reduce the number of semaphores used under --disable-spinlocks.