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? -- 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
