Postgres Pro
Downloads
Home   >   mailing lists

Re: [PATCH] Increase the maximum value track_activity_query_size - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: [PATCH] Increase the maximum value track_activity_query_size
Date
Msg-id 20191221024757.GF15758@paquier.xyz
Whole thread Raw
In response to Re: [PATCH] Increase the maximum value track_activity_query_size  (Bruce Momjian <bruce@momjian.us>)
Responses Re: [PATCH] Increase the maximum value track_activity_query_size  (Nikolay Samokhvalov <samokhvalov@gmail.com>)
List pgsql-hackers
Tree view 
On Fri, Dec 20, 2019 at 08:57:04AM -0500, Bruce Momjian wrote:
> I can imagine using larger pgstat_track_activity_query_size values for
> data warehouse queries, where they are long and there are only a few of
> them.

Why are those queries that long anyway?  A too long IN clause with an
insane amount of parameters which could be replaced by an ANY clause
with an array?
--
Michael
Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: MarkBufferDirtyHint() and LSN update
Next
From: Michael Paquier
Date:
Subject: Re: automating pg_config.h.win32 maintenance