Re: Hash id in pg_stat_statements

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Hash id in pg_stat_statements
Дата
Msg-id 20121001161241.GV1267@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: Hash id in pg_stat_statements  (Peter Geoghegan <peter@2ndquadrant.com>)
Ответы Re: Hash id in pg_stat_statements
Список pgsql-hackers
Peter, all,

* Peter Geoghegan (peter@2ndquadrant.com) wrote:
> Well, I'll point out once again that the argument about its stability
> is invalid, because we serialise the entries to disk. If a point
> release changes the representation of the query tree such that the
> hash values won't match, then we have no recourse but to bump
> pg_stat_statements version number, and invalidate all existing
> entries.

What if we simply included the pg_stat_statements version number in
what's shown to the user as the 'hash'?  ver#.hash ?
Thanks,
    Stephen

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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: CTE optimization fence on the todo list?
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Hash id in pg_stat_statements