Tag Info

New answers tagged

1

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.


3

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