1-/2-dimensional indexes for common columns, rationale?

Поиск
Список
Период
Сортировка
От Marinos Yannikos
Тема 1-/2-dimensional indexes for common columns, rationale?
Дата
Msg-id 47EA5B4D.5000300@geizhals.at
обсуждение исходный текст
Ответы Re: 1-/2-dimensional indexes for common columns, rationale?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Список pgsql-performance
Hello,

we have several indexes such as:

create index foo1 on bla (a);
create index foo2 on bla (b);
create index foo3 on bla (a,b);

They are all used often by frequently used queries (according to
pg_statio_user_indexes), but we need somewhat higher INSERT/UPDATE
performance (having tuned most other things) so we'd like to remove some.

Which of the above would generally speaking be most redundant / best to
remove? Is a 2-dimensional index always much slower than a 1-dimensional
with the first column for queries on the first column? Any other
suggestions?

Thanks,
  Marinos


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

Предыдущее
От: Matthew
Дата:
Сообщение: Re: what is the maximum number of rows in a table in postgresql 8.1
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: 1-/2-dimensional indexes for common columns, rationale?