wasn't that improved now in 8.4, and before that on 8.3 ? still there are some funny things with distinct/group by . for instance, try select count(distinct foo) from bar; vs select count(1) from (select distinct foo from bar) f; :) I am not sure it pg was able to use index for that in 8.2. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general