Re: Hashtable entry recycling algorithm in pg_stat_statements

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Hashtable entry recycling algorithm in pg_stat_statements
Дата
Msg-id 14884.1230945832@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Hashtable entry recycling algorithm in pg_stat_statements  ("Alex Hunsaker" <badalex@gmail.com>)
Ответы Re: Hashtable entry recycling algorithm in pg_stat_statements  ("Alex Hunsaker" <badalex@gmail.com>)
Список pgsql-hackers
"Alex Hunsaker" <badalex@gmail.com> writes:
> Its seems to me a linear list would make the "common" case where the
> query is already in the list but we need to update the stats slow.

No, the hashtable is still there for lookups.  The list would be a means
of determining which hashtable entry to release when we're out of space.
        regards, tom lane


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

Предыдущее
От: "Alex Hunsaker"
Дата:
Сообщение: Re: Hashtable entry recycling algorithm in pg_stat_statements
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Significantly larger toast tables on 8.4?