Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group