Re: [COMMITTERS] pgsql: Rearm statement_timeout after each executedquery.

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: [COMMITTERS] pgsql: Rearm statement_timeout after each executedquery.
Дата
Msg-id 6a909374-2602-7136-8c70-397330a418f3@2ndquadrant.com
обсуждение исходный текст
Ответы Re: [COMMITTERS] pgsql: Rearm statement_timeout after each executed query.
Список pgsql-hackers
On 9/18/17 22:41, Andres Freund wrote:
> Rearm statement_timeout after each executed query.

This appears to have broken statement_timeout behavior in master such
that only every second query is affected by it.  For example:

create table t1 as select * from generate_series(0, 100000000) as _(a);
set statement_timeout = '1s';
explain analyze select from t1 where a = 55;  -- gets canceled
explain analyze select from t1 where a = 55;  -- completes (>1s)
explain analyze select from t1 where a = 55;  -- gets canceled
explain analyze select from t1 where a = 55;  -- completes (>1s)
etc.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: [HACKERS] MERGE SQL Statement for PG11
Следующее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: Query running for very long time (server hanged) with parallelappend