Postgres Pro
Downloads
Home   >   mailing lists

Re: Storing pg_stat_statements query texts externally, pg_stat_statements in core - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: Storing pg_stat_statements query texts externally, pg_stat_statements in core
Date
Msg-id CAM3SWZQm4h1OiGkprMa8V+4ZFTMiuYO0V3USFpO4Ywbujg1mKQ@mail.gmail.com
Whole thread Raw
In response to Re: Storing pg_stat_statements query texts externally, pg_stat_statements in core  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
On Wed, Jan 22, 2014 at 1:38 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Hm, are there 5K distinct queries in the regression tests?  I'd have
> thought they weren't enough to fill a large pgss hash.

Well, yes. They're a really bad case for pg_stat_statements, in that
almost all distinct queries are only executed once or twice and yet
there are enough of them. I think this is generally useful for
testing.


-- 
Peter Geoghegan

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Storing pg_stat_statements query texts externally, pg_stat_statements in core
Next
From: Jon Nelson
Date:
Subject: Re: PoC: Duplicate Tuple Elidation during External Sort for DISTINCT