Re: SUBSTRING performance for large BYTEA

"Joshua D. Drake" <jd@commandprompt.com> writes:
> Should we consider setting storage external by default for the type?

No.  That would be counterproductive for the more typical case of bytea
values in the range of some-small-number-of-kilobytes.  Or at least
I think that's more typical than values that are so large you have to go
out of your way to fetch them in chunks.

            regards, tom lane