"Stefan Kaltenbrunner" <stefan@kaltenbrunner.cc> writes:
> http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=lionfish&dt=2007-07-24%2005:30:13
That's just a faulty test:
SELECT t.d1 + i.f1 AS "102" FROM TIMESTAMP_TBL t, INTERVAL_TBL i WHERE t.d1 BETWEEN '1990-01-01' AND '2001-01-01' AND
i.f1BETWEEN '00:00' AND '23:00';
Note that there's no ORDER BY on the test. I bet the planner came up with an
entirely different plan than usual which generated the records in a different
order.
Offhand I can only think of one kind of plan myself but I'm sure the planner
is more inventive than me :)
-- Gregory Stark EnterpriseDB http://www.enterprisedb.com