Hi Aaron, > On MySQL: > 4543 rows in set (0.28 sec) > 41573 rows in set (1.69 sec) > > So if this fixes it for Pg, then I think we've got a winner :-)
'in set' means 4543 results? Is there something like explain analyze in MySQL too? Could you please post results? 0,04 ms per result in case of the 42k rows - that sounds like a in-memory database. Thomas -- http://www.tmueller.com for pgp key (95702B3B)