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