[jimktrains2]

Yes, in PG at least an index is created, otherwise the unique check would become prohibitive.

[cheapsteak]

I think the question is more on whether a duplicate index would be created instead of having the unique constraint and primary key designation on the same column share an index