"James DeMichele" <[EMAIL PROTECTED]> wrote ..
> Then, I have the following index on the table:
> "this_index" (status, source_id, <another_column>)
If you have many queries of this type, do
CLUSTER this_index ON tablename;
and retry the SELECT.
MySQL is using some sort of auto-clustering ISAM on the other box mayhaps?
In Postgres you will have to re-CLUSTER periodically if there are INSERTs and
UPDATEs.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
