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
In response to
pgsql-novice by date
|Next:||From: sdeel||Date: 2002-08-08 03:52:56|
|Subject: Re: Permissions problem on new install |
|Previous:||From: Tom Lane||Date: 2002-08-08 02:25:05|
|Subject: Re: MemoryContextAlloc: invalid request size 1969649011 |