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.