On Thu, May 24, 2012 at 2:59 PM, Thom Brown <thom(at)linux(dot)com> wrote:
> On 24 May 2012 13:54, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>> On Thu, May 24, 2012 at 2:49 PM, Thom Brown <thom(at)linux(dot)com> wrote:
>>> 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:
>>>>> 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
>>>> 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?
Ah, suddenly it makes sense.
And in that case yes, the docs changes should go under
pg_stat_statements, I believe.
In response to
pgsql-docs by date
|Next:||From: Tom Lane||Date: 2012-05-24 14:19:10|
|Subject: Re: track_activity_query_size note |
|Previous:||From: Thom Brown||Date: 2012-05-24 12:59:53|
|Subject: Re: track_activity_query_size note|