Hi,
this is probably an old issue but I'm not all that experienced. I wonder if an index can be accessed rather directly, as to speed upa query like "select count(distinct())", by simply calculating the number of branches (leaves) an index has. Or at least to skip sorting.
Best regards, Zdravko -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql