track_activity_query_size change from default 1024 to higher values like 4096+

From: Radovan Jablonovsky <radovan(dot)jablonovsky(at)replicon(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: track_activity_query_size change from default 1024 to higher values like 4096+
Date: 2014-11-04 22:16:50
Message-ID: CAJYcdTvvxMSBrE4yJjfJJMUjHQP3-o0txDrqJ=GTXRGmxS79wA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,
Are there some know performance or other side effect(s) when changing
track_activity_query_size from 1024 to 4096+ size. Obvious requirement will
be on the increase of memory (4+ times) to store the query string.

Sincerely,
--

*Radovan Jablonovsky* | SaaS DBA | Phone 1-403-262-6519 (ext. 7256) | Fax
1-403-233-8046

*Replicon | Hassle-Free Time & Expense Management Software - 7,300
Customers - 70 Countrieswww.replicon.com
<http://www.replicon.com/> | facebook
<http://www.facebook.com/Replicon.inc> | twitter
<http://twitter.com/Replicon> | blog
<http://www.replicon.com/blog/> | contact us
<http://www.replicon.com/about_replicon/contact_us.aspx>We are
hiring! | search jobs
<http://tbe.taleo.net/NA2/ats/careers/searchResults.jsp?org=REPLICON&cws=1&act=sort&sortColumn=1&__utma=1.651918544.1299001662.1299170819.1299174966.10&__utmb=1.8.10.1299174966&__utmc=1&__utmx=-&__utmz=1.1299174985.10.3.utmcsr=google%7Cutmccn=(organic)%7Cutmcmd=organic%7Cutmctr=replicon%20careers&__utmv=1.%7C3=Visitor%20Type=Prospects=1,&__utmk=40578466>*

Browse pgsql-admin by date

  From Date Subject
Next Message Davenport, Julie 2014-11-04 22:57:58 Re: WARNING: psql version 8.4, server version 9.2.
Previous Message Raghu Ram 2014-11-04 12:01:32 Re: Pgpool 2