Multiple Indexing, performance impact

Поиск

Список

Период

Сортировка

От	Daniel Åkerud
Тема	Multiple Indexing, performance impact
Дата	22 июня 2001 г. 14:25:30
Msg-id	000a01c0fb45$fffcb2c0$c901a8c0@automatic100 обсуждение исходный текст
Ответы	Re: Multiple Indexing, performance impact
Список	pgsql-general

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

В списке pgsql-general по дате отправления: