To follow up... I did a full vacuum analyze on both tables and re-ran the query. Same story. I ended the query after eight minutes. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general