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?  (Josh Berkus <josh@agliodbs.com>)
Re: single index on more than two coulumns a bad thing?  (Greg Stark <gsstark@mit.edu>)
Re: single index on more than two coulumns a bad thing?  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-performance
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"
Дата:
Сообщение: PostgreSQL and Linux 2.6 kernel.
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: single index on more than two coulumns a bad thing?