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

From Peter Geoghegan
Subject Re: Hash id in pg_stat_statements
Date
Msg-id CAEYLb_UQnx1+Q7+gPHyssBCpVH55niM4dfwd43zGe8_tYW5Fnw@mail.gmail.com
Whole thread Raw
In response to Re: Hash id in pg_stat_statements  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
On 2 October 2012 17:58, Stephen Frost <sfrost@snowman.net> wrote:
> Right, and that's all I'm trying to address here- how do we provide a
> value for a given query which can be relied upon by outside sources,
> even in the face of a point release which changes what our internal hash
> value for a given query is.

I don't know of a way. Presumably, we'd hope to avoid this, and would
look for alternatives to anything that would necessitate bumping
PGSS_FILE_HEADER, while not going so far as to let pg_stat_statements
contort things in the core system. If I was aware of a case where this
would have come up had pg_stat_statements fingerprinting been around
at the time, perhaps I could give a better answer than that.

-- 
Peter Geoghegan       http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: CREATE SCHEMA IF NOT EXISTS
Next
From: Alvaro Herrera
Date:
Subject: Re: CREATE SCHEMA IF NOT EXISTS