Re: Increasing the length of pg_stat_activity.current_query...

Поиск
Список
Период
Сортировка
От Sean Chittenden
Тема Re: Increasing the length of pg_stat_activity.current_query...
Дата
Msg-id 545E4BF8-302D-11D9-9442-000A95C705DC@chittenden.org
обсуждение исходный текст
Ответ на Re: Increasing the length of pg_stat_activity.current_query...  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Increasing the length of pg_stat_activity.current_query...
Список pgsql-hackers
>> Is there any reason the length of
>> pg_catalog.pg_stat_activity.current_query is capped at 255 characters?
>
> The reason for a limit is to avoid fragmentation of UDP messages.
> I believe we've set it at 1K for 8.0, though, and if you are on
> a platform with a higher message size limit you could raise it more.

I'm confused... UDP as in the UDP/IP?  RPC caps UDP messages at 8K and 
NFS over UDP often runs at 32K...  where is UDP used in the backend?  
-sc

-- 
Sean Chittenden



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Increasing the length of pg_stat_activity.current_query...
Следующее
От: Tom Lane
Дата:
Сообщение: relative_path() seems overly complicated and buggy