Re: Hash id in pg_stat_statements - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Hash id in pg_stat_statements
Date
Msg-id 20121001161241.GV1267@tamriel.snowman.net
Whole thread Raw
In response to Re: Hash id in pg_stat_statements  (Peter Geoghegan <peter@2ndquadrant.com>)
Responses Re: Hash id in pg_stat_statements  (Peter Geoghegan <peter@2ndquadrant.com>)
List 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 by date:

Previous
From: Stephen Frost
Date:
Subject: Re: CTE optimization fence on the todo list?
Next
From: Peter Geoghegan
Date:
Subject: Re: Hash id in pg_stat_statements