Why is so fast ? is It magic ?

Hi,

I'm testing how fast PostgreSql is.

I have 2 tables :

the first one has 87000 records and the second one has 8700.

this is my code :

BEGIN;

DECLARE CURSOR TEST FOR SELECT FIELD1,FIELD2,FIELD3 FROM TABLE1
LEFT JOIN TABLE2 ON FIELD1 = FIELD2
ORDER BY FIELD3

FETCH 10 IN TEST;
FETCH 10 IN TEST;
FETCH 10 IN TEST;
FETCH 10 IN TEST; ....(continue up to the last record)

The FIELD3 is a Char FIELD in the second table and It's not indexed.

This test results in 87000 records ordered by a field on a second table which doesn't have an index.

It's take only 40 seconds in a Pentium IV 2.4 GHZ with 512MB.

How postgres does that so fast ?

Am I doing something wrong or It's really fast ?

Thanks.

wmiro.