track_activity_query_size change from default 1024 to higher values like 4096+ - Mailing list pgsql-admin

From Radovan Jablonovsky
Subject track_activity_query_size change from default 1024 to higher values like 4096+
Date
Msg-id CAJYcdTvvxMSBrE4yJjfJJMUjHQP3-o0txDrqJ=GTXRGmxS79wA@mail.gmail.com
Whole thread Raw
List 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 Countries
www.replicon.com | facebook | twitter | blog | contact us

We are hiring! | search jobs

pgsql-admin by date:

Previous
From: Raghu Ram
Date:
Subject: Re: Pgpool 2
Next
From: "Davenport, Julie"
Date:
Subject: Re: WARNING: psql version 8.4, server version 9.2.