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/ -- Thom -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
