Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> Not having the whole query is painful. Raising it to 1K doesn't get
> round the fact that it's the longer queries that tend to be the more
> painful ones, and so they are the ones you want to trap in full and
> EXPLAIN, so you can find out if they are *ever* coming back.
... so look in the postmaster log ...
> I'd vote in favour of relaxing the limit entirely, as Sean suggests.
The choice is not between "limit" and "no limit", it is between
"limit" and "broken".
regards, tom lane