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

From Daniel Farina
Subject Re: Hash id in pg_stat_statements
Date
Msg-id CAAZKuFY+RxSZR3KOxD58_LQMgs56MfXEU2Ar6WeEhQKNp04hWQ@mail.gmail.com
Whole thread Raw
In response to Re: Hash id in pg_stat_statements  (Peter Geoghegan <peter@2ndquadrant.com>)
List pgsql-hackers
On Mon, Oct 15, 2012 at 7:35 AM, Peter Geoghegan <peter@2ndquadrant.com> wrote:
> On 3 October 2012 19:04, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Daniel Farina <daniel@heroku.com> writes:
>>> Instead, I think it makes sense to assign a number -- arbitrarily, but
>>> uniquely -- to the generation of a new row in pg_stat_statements, and,
>>> on the flip side, whenever a row is retired its number should be
>>> eliminated, practically, for-ever.  This way re-introductions between
>>> two samplings of pg_stat_statements cannot be confused for a
>>> contiguously maintained statistic on a query.
>>
>> This argument seems sensible to me.
>
> Daniel: Could you please submit the patch that you were working on
> that does this to the next commitfest?

Yes. Sorry I haven't done that already.  I'll clean it up and send it
out Real Soon Now, thanks for the expression of interest.

-- 
fdr



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Deprecating Hash Indexes
Next
From: Andres Freund
Date:
Subject: Re: Deprecating Hash Indexes