Re: Effective limit on size of text type?

eric soroos <eric-psql(at)soroos(dot)net> writes:
> test=# select _incomingEnclosures from dl_event where _idNum=3010;
> Takes at least a couple of minutes, either through psql or a libpq based connection.
> test=# select char_length(_incomingEnclosures) from dl_event where _donorNum=804 and _responseNum=3010;
> -[ RECORD 1 ]-------
> char_length | 952478
> Is nearly immediate.

Given that those queries aren't using comparable WHERE conditions, I'd
wonder about the query plan myself, not the size of the returned data
item. Do you have an index on _idNum? Is it getting used?

In a quick test here, selecting a 1MB text value into a file, using

regression=# select f1 from foo
regression-# \g tmpfile

took about a tenth of a second...

regards, tom lane