Re: Backend Stats Enhancement Request

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Miller <miller392(at)yahoo(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Backend Stats Enhancement Request
Date: 2008-06-19 15:07:52
Message-ID: 12799.1213888072@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

David Miller <miller392(at)yahoo(dot)com> writes:
> I would like to request a change to the PGBE_ACTIVITY_SIZE #define in the pgstat.h file. This value determines the max length 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 just pgAdmin 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David Miller 2008-06-19 15:19:51 Re: Backend Stats Enhancement Request
Previous Message David Miller 2008-06-19 14:54:26 Backend Stats Enhancement Request