Re: Why does pg_stat_activity Truncate Queries?

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема Re: Why does pg_stat_activity Truncate Queries?
Дата
Msg-id 413E43E8.2040302@bigfoot.com
обсуждение исходный текст
Ответ на Re: Why does pg_stat_activity Truncate Queries?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
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




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Making AFTER triggers act properly in PL functions
Следующее
От: Tiago Wright
Дата:
Сообщение: Re: Indexed views?