Foreign key - Indexing & Deadlocking.

Hi,

I'm porting some Oracle software to PostgreSQL, & have a question about best practices with foreign keys.

In the Oracle environment, you're basically obliged to index all foreign keys (more specifically foreign key columns should appear on the leading edge of an index) due to the way that it manages locks.

Failure to index foreign keys in this way in Oracle often causes deadlock situations.

Although I could no find a mention of anything similar in the postgreSQL documentation, I just wanted to check whether or not the same was true of PostgreSQL to be on the safe side.

Thanks,

Andrew.

_________________________________________________________________
Use Hotmail to send and receive mail from your different email accounts
http://clk.atdmt.com/UKM/go/186394592/direct/01/