Document use of partial indexes for partial unique constraints

Report by Tomáš Greif

Backpatch through 9.4