> > W dniu 23.02.2016 o 09:39, Rafal Pietrak pisze: > > Can anybody suggest any other way out of this mass? >
The only thought that sticks while reading your prose is: message ----> message-person <---- person message-person (message_id, person_id, relationship_type[sender, receiver]) Partitioning and partial indexes both have considerable limitations that you might need to work around. That said normalization exists for a reason and having multiple "person" columns in a table is a form of duplication that if left presents just the problems you are seeing. I suspect your SSN should fit onto the message-person table. The following doesn't make sense - if the SSN is sender unique then there is no expectation that a receiver would not receive two messages with the same SSN from different senders. ALTER ... msgs_to_me ADD CONSTRINT them_uniq UNIQUE (THEM,SSN); David J.
