Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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



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




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group