Re: Add min and max execute statement time in pg_stat_statement

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Add min and max execute statement time in pg_stat_statement
Дата
Msg-id 20141221182326.GA1768@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Add min and max execute statement time in pg_stat_statement  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: Add min and max execute statement time in pg_stat_statement  (Andres Freund <andres@anarazel.de>)
Re: Add min and max execute statement time in pg_stat_statement  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
Andrew Dunstan wrote:

> On my blog Peter Geoghegan mentioned something about "atomic fetch-and-add"
> being useful here, but I'm not quite sure what that's referring to. Perhaps
> someone can give me a pointer.

The point, I think, is that without atomic instructions you have to hold
a lock while incrementing the counters.

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



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PrivateRefCount patch has got issues
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Add min and max execute statement time in pg_stat_statement