Josh Berkus <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
