Folks,

I was just noticing that pg_stat_activity is truncating queries which are 
logged to it at about 150 chars.   I can't think of any good reason for this.   
Is there one?

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

Tue, 7 Sep 2004 14:53:13 -0700
Josh Berkus <josh@agliodbs.com>
Why does pg_stat_activity Truncate Queries?
Josh Berkus <josh@agliodbs.com> writes:
> I was just noticing that pg_stat_activity is truncating queries which are 
> logged to it at about 150 chars.

256, I would expect.

> I can't think of any good reason for this.

There is good reason to limit the packet size, but to a kilobyte or so.
Feel free to bump up PGSTAT_ACTIVITY_SIZE to 1000 or so in
src/include/pgstat.h (and yes, this is already done for 8.0).

			regards, tom lane

Tue, 07 Sep 2004 18:43:26 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Why does pg_stat_activity Truncate Queries? 
Tom Lane wrote:

> Josh Berkus <josh@agliodbs.com> writes:
> 
>>I was just noticing that pg_stat_activity is truncating queries which are 
>>logged to it at about 150 chars.
> 
> 
> 256, I would expect.
> 
> 
>>I can't think of any good reason for this.
> 
> 
> There is good reason to limit the packet size, but to a kilobyte or so.
> Feel free to bump up PGSTAT_ACTIVITY_SIZE to 1000 or so in
> src/include/pgstat.h (and yes, this is already done for 8.0).
> 

I didn't see this changement in the 8.0 release note, don't you think shall
be added ?


Regards
Gaetano Mendola



Wed, 08 Sep 2004 01:27:36 +0200
Gaetano Mendola <mendola@bigfoot.com>
Re: Why does pg_stat_activity Truncate Queries?