From: | Thom Brown <thom(at)linux(dot)com> |
---|---|
To: | Magnus Hagander <magnus(at)hagander(dot)net> |
Cc: | pgsql-docs <pgsql-docs(at)postgresql(dot)org> |
Subject: | Re: track_activity_query_size note |
Date: | 2012-05-24 12:59:53 |
Message-ID: | CAA-aLv7rKz7H=iaKKKv8-J6mJ7QC+K6zwgb9g+vR2wGaA4-2nQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
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:
>>>> 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?
s/pg_stat_statistics/pg_stat_statements/
--
Thom
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2012-05-24 13:03:56 | Re: track_activity_query_size note |
Previous Message | Magnus Hagander | 2012-05-24 12:54:42 | Re: track_activity_query_size note |