I just made i simple little test application inserting 50'000 'pwgen 8' data into a table with only a primary key id and a text column.
In every run, it is all deleted and the tables are vacuumed.
Having one separate index on name it took 36 seconds
Having an additional index, also on name, it took 69 seconds.
Furthermore:
3 indexes: 97 seconds
4 indexes: 131 seconds
5 indexes: 163 seconds
6 indexes: 210 seconds
7 indexes: 319 seconds
8 indexes: 572 seconds
9 indexes: 831 seconds
10 indexes: 1219 seconds
Anyone know what causes the signifacant performance decrease after 7 indexes?
Daniel Åkerud