From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Peter Geoghegan <pg(at)heroku(dot)com> |
Cc: | Andres Freund <andres(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: 9.4 release notes |
Date: | 2014-05-05 23:14:19 |
Message-ID: | 20140505231419.GO29541@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, May 5, 2014 at 02:23:13PM -0700, Peter Geoghegan wrote:
> On Sun, May 4, 2014 at 6:49 AM, Andres Freund <andres(at)2ndquadrant(dot)com> wrote:
> > + <listitem>
> > + <para>
> > + Have pg_stat_statements use a flat file for query text storage, allowing higher limits (Peter Geoghegan)
> > + </para>
> > +
> > + <para>
> > + Also add the ability to retrieve all pg_stat_statements information except the query text. This allows programs to reuse the query
> > + text already retrieved by referencing queryid.
> > + </para>
> > + </listitem>
> >
> > This isn't an optional thing, is it?
>
> This is intended to be used by time-series monitoring tools that
> aggregate and graph pg_stat_statements data temporally. They usually
> won't need query texts, and so can only retrieve them lazily. The
> pg_stat_statements view presents exactly the same interface for ad-hoc
> querying, though.
>
> The point of the first item is that there is no longer *any*
> limitation on the size of stored query texts. They are no longer
> truncated to track_activity_query_size bytes. The shared memory
> overhead is also decreased substantially, allowing us to increase the
> default pg_stat_statements.max setting from 1,000 to 5,000, while
> still reducing the overall shared memory overhead (assuming a default
> track_activity_query_size). I think that the removal of the
> limitation, and the substantial lowering of the per-entry footprint
> should both be explicitly noted.
We rarely get into specific numers like this. It says "higher limit(s)" and
hopefully that is enough. If you want to create a documentation 'id' I
can like to that for the "higher limits" text.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2014-05-05 23:16:18 | Re: 9.4 release notes |
Previous Message | Thomas Munro | 2014-05-05 23:03:34 | Re: Cluster name in ps output |