single index on more than two coulumns a bad thing?

Поиск
Список
Период
Сортировка
Искать
От
Palle Girgensohn
Тема
single index on more than two coulumns a bad thing?
Дата
Msg-id
24070000.1080860445@palle.girgensohn.se
Список
Дерево обсуждения
Re: single index on more than two coulumns a bad thing? "Aaron Werman" <awerman2@hotmail.com>
Hi,

I remember reading a post ages ago, maybe from Vadim, about the fact that 
people creating indices on more than two columns will be the first to be 
put againts the wall when the revolution comes... sort of...

Is it always bad to create index xx on yy (field1, field2, field3);

I guess the problem is that the index might often grow bigger than the 
table, or at least big enough not to speed up the queries?

/Palle

В списке pgsql-performance по дате отправления
От: Gary Doades
Дата:
От: Josh Berkus
Дата:
FAQ