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

Sean Chittenden <sean@chittenden.org> writes:
> 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.
        regards, tom lane