Hello!
I'm thinking about two things:
1. what index is faster to scan (for select ... where statements) unique
or not unique ?
2. can the unique index to slow inserts commands (in comparison with not
unique index) ?
Best regards
Adam

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Sorry for question. I've tested it by myself. There is no significant
differences.
Adam

Adam Rad³owski napisa³(a):
> Hello!
> I'm thinking about two things:
> 1. what index is faster to scan (for select ... where statements) unique
> or not unique ?
> 2. can the unique index to slow inserts commands (in comparison with not
> unique index) ?
> Best regards
> Adam
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly