Re: Backend Stats Enhancement Request - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Backend Stats Enhancement Request
Date
Msg-id 12799.1213888072@sss.pgh.pa.us
Whole thread Raw
In response to Backend Stats Enhancement Request  (David Miller <miller392@yahoo.com>)
List pgsql-hackers
David Miller <miller392@yahoo.com> writes:
> I would like to request a change to the PGBE_ACTIVITY_SIZE #define in the pgstat.h file. This value determines the
maxlength of the SQL query contained in the PgBackendStatus structure. 
 
> By increasing the value of this #define to 32768 we are able to capture queries larger than the 1024 default using
justpgAdmin or Postgres Studio. I would like to have this change considered for future releases.
 

Highly unlikely that we'd push it so high, because of the amount of
shared memory it would eat.
        regards, tom lane


pgsql-hackers by date:

Previous
From: David Miller
Date:
Subject: Backend Stats Enhancement Request
Next
From: David Miller
Date:
Subject: Re: Backend Stats Enhancement Request