> 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? Refering the discussion here, I assume I am correct: http://groups.google.co.in/group/pgsql.general/browse_thread/thread/516db5b5f36c82d0 thanks Sanjay ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly