Skip site navigation (1) Skip section navigation (2)

Re: track_activity_query_size note

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Thom Brown <thom(at)linux(dot)com>
Cc: pgsql-docs <pgsql-docs(at)postgresql(dot)org>
Subject: Re: track_activity_query_size note
Date: 2012-05-24 12:39:48
Message-ID: CABUevEz1GTbCj_ctv2PBrMXMQc167TesaUQ34NanBZQY51eGaw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-docs
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.

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

In response to

Responses

pgsql-docs by date

Next:From: Thom BrownDate: 2012-05-24 12:49:01
Subject: Re: track_activity_query_size note
Previous:From: Thom BrownDate: 2012-05-24 12:16:40
Subject: track_activity_query_size note

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group