pgsql: Improve management of "sticky" entries in contrib/pg_stat_statem

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Improve management of "sticky" entries in contrib/pg_stat_statem
Дата
Msg-id E1SGy81-00061S-Mm@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Improve management of "sticky" entries in contrib/pg_stat_statements.

This patch addresses a deficiency in the previous pg_stat_statements patch.
We want to give sticky entries an initial "usage" factor high enough that
they probably will stick around until their query is completed.  However,
if the query never completes (eg it gets an error during execution), the
entry shouldn't persist indefinitely.  Manage this by starting out with
a usage setting equal to the (approximate) median usage value within the
whole hashtable, but decaying the value much more aggressively than we
do for normal entries.

Peter Geoghegan

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/d5375491f8e391224b48e4bb449995a4642183ea

Modified Files
--------------
contrib/pg_stat_statements/pg_stat_statements.c |   57 +++++++++++++++++------
1 files changed, 42 insertions(+), 15 deletions(-)


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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: pgsql: Do stack-depth checking in all postmaster children.
Следующее
От: Robert Haas
Дата:
Сообщение: pgsql: Teach SLRU code to avoid replacing I/O-busy pages.