Re: Why does pg_stat_activity Truncate Queries?

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Why does pg_stat_activity Truncate Queries?
Date: 2004-09-07 23:27:36
Message-ID: 413E43E8.2040302@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:

> Josh Berkus <josh(at)agliodbs(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tiago Wright 2004-09-07 23:52:08 Re: Indexed views?
Previous Message Tom Lane 2004-09-07 23:13:11 Re: Making AFTER triggers act properly in PL functions