New answers tagged pgadmin
I discovered that pgAdmin III does this by default. When you create a new foreign key constraint using the GUI, there is a checkbox "Auto FK Index" on the Definition tab. I hadn't noticed this until just now so it explains why the index was being created.
What could explain why this gets created? You created the index. Or the client software you are working with did it for you. Postgres certainly didn't. Do I still need to create another index on my product column to improve performance of queries on it? No. A second index on the same column would be a total waste. It's not even certain the first ...
Top 50 recent answers are included