On Thu, May 24, 2012 at 2:59 PM, Thom Brown <[email protected]> wrote: > On 24 May 2012 13:54, Magnus Hagander <[email protected]> wrote: >> On Thu, May 24, 2012 at 2:49 PM, Thom Brown <[email protected]> wrote: >>> On 24 May 2012 13:39, Magnus Hagander <[email protected]> wrote: >>>> On Thu, May 24, 2012 at 2:16 PM, Thom Brown <[email protected]> wrote: >>>>> Hi, >>>>> >>>>> I attach a proposed change to the docs which points out that if the >>>>> size of track_activity_query_size is changed and the is server >>>>> restarted, it won't have any effect if query statistics are already >>>>> present. >>>> >>>> But aren't pg_stat_activity queries always cleared when you restart >>>> the server - because they are all disconnected... And you can't change >>>> track_activity_query_size without restarting. >>> >>> But not pg_stat_statistics queries, which is where I should have >>> probably made the note. Restarting the server won't change the length >>> of the field if there's already data present in pg_stat_statistics, >>> but upon resetting them, the field is appropriately sized. >> >> Uh, what's pg_stat_statistics? > > s/pg_stat_statistics/pg_stat_statements/
Ah, suddenly it makes sense. And in that case yes, the docs changes should go under pg_stat_statements, I believe. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
