Hannu Krosing <hannu@tm.ee> writes:
>> the results
>> of 31220 matches <10 sec
>> at 16002 matches <5 sec
>> PostgreSQL 24807 matches <10 sec
>> I infinite, (maybe computer crash ?, www.postgresql.org also
>> unreachable)
> Seems it survived (result after ~5 min) 35827 matches.
> During the search www.postgresql.org was unreachable at least from my
> computer.
Sounds to me like you were seeing a transient network outage. The
35k-row query probably didn't take *that* much longer than the 31k-row
query --- but maybe www.postgresql.org's packets couldn't get to you
for awhile.
regards, tom lane
