Re: track_activity_query_size note

On 24 May 2012 13:39, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> On Thu, May 24, 2012 at 2:16 PM, Thom Brown <thom(at)linux(dot)com> 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