Re: track_activity_query_size note

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

Uh, what's pg_stat_statistics?

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/