> Would a rule be that
> if the first attribute of an index is unique, then additional
> attributes are basically useless?
For PostgreSQL this is currently true, since indexes are currently not
used for order by. If you have a unique first column in an index,
then all following columns could only be used for sorting,
not for faster access (access actually gets worse).
Andreas