Impact of track_activity_query_size on high traffic OLTP system

From: Jeremy Finzel <finzelj(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Impact of track_activity_query_size on high traffic OLTP system
Date: 2017-04-13 20:45:49
Message-ID: CAMa1XUiR2YSg9YdMT4oYC8P-M++7+Wj=twVVOGgkgW+5BMhViA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I have found some examples of people tweaking this
parameter track_activity_query_size to various setting such as 4000, 10000,
15000, but little discussion as to performance impact on memory usage.
What I don't have a good sense of is how significant this would be for a
high traffic system with rapid connection creation/destruction, say 1000s
per second. In such a case, would there be a reason to hesitate raising it
to 10000 from 1024? Is 10k memory insignificant? Any direction here is
much appreciated, including a good way to benchmark this kind of thing.

Thanks!

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Rick Otten 2017-04-13 21:17:07 Re: Impact of track_activity_query_size on high traffic OLTP system
Previous Message Reza Taheri 2017-04-13 19:30:54 Postgresql, and ODBC handles