Hi All, I think PostgreSQL does not create indexes on foreign keys of a table, and I have to do so explicitly. That means, wherever I am using master- detail table, I have to create explicit indexes on the foreign key in the detail table. Am I wrong? thanks Sanjay ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster